•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 402,745 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,523 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums
Views: 5854 | Replies: 1
 |
•
•
Join Date: Mar 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
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.
•
•
Join Date: Aug 2007
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
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.
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Learning PHP but problem with script (PHP)
- script to call google search? (Perl)
- ftp and compare script (Shell Scripting)
- help with script (PHP)
- I want to create a community script (PHP)
- Login used to work (ASP.NET)
- question about connecting odbc to sql through php script (PHP)
- login script using sessions (PHP)
Other Threads in the Oracle Forum
- Previous Thread: Question
- Next Thread: Meaning of i and g in Oracle 9i & 10g
