| | |
How to create script of a user/role
Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Mar 2007
Posts: 1
Reputation:
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.
![]() |
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: Differences between versions of oracle
| Thread Tools | Search this Thread |
2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy editor enterprise enterprise2.0 enterprisesoftware federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sql sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho





