How to create script of a user/role

Reply

Join Date: Mar 2007
Posts: 1
Reputation: 53050373 is an unknown quantity at this point 
Solved Threads: 0
53050373 53050373 is offline Offline
Newbie Poster

How to create script of a user/role

 
0
  #1
Mar 7th, 2007
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.
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 6
Reputation: Musta is an unknown quantity at this point 
Solved Threads: 0
Musta Musta is offline Offline
Newbie Poster

Re: How to create script of a user/role

 
0
  #2
Aug 23rd, 2007
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC