954,561 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

How to create script of a user/role

Hi.
In Toad, I can select a user/role, right click, and select "Create script", and it creates a SQL script of the user/role definition. I find this handy if I only want the user/role definition and not want to export/import any data. Does anyone know how to obtain/create/export a user/role definition using SQL Plus in Oracle 9i (assuming I have the privileges)? I'm fine as long as I can read it in text format. Thanks.

53050373
Newbie Poster
1 post since Mar 2007
Reputation Points: 10
Solved Threads: 0
 

Every transaction you do in toad, you can see a scripr for it..
while if you are looking to create your own script this you need to be clearer.
The Export utility can create a dump file for a full schema, as in :
user, his roles and privileges and his owned tables.

Musta
Newbie Poster
6 posts since Aug 2007
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You