•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 370,606 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,049 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:
Views: 5311 | Replies: 1
![]() |
•
•
Join Date: Mar 2007
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
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.
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
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


Linear Mode