Home » RDBMS Server » Backup & Recovery » How to create script of a user/role definition
icon5.gif  How to create script of a user/role definition [message #213878] Fri, 12 January 2007 11:04 Go to next message
DrNeko
Messages: 17
Registered: January 2007
Location: NJ
Junior Member
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.
Re: How to create script of a user/role definition [message #213887 is a reply to message #213878] Fri, 12 January 2007 12:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
So, you want a script that will get ddl of user along with user's grants?
http://www.orafaq.com/forum/m/120560/42800/?srch=cr_user_like#msg_120560
For Roles, you can tweak the script.
Re: How to create script of a user/role definition [message #214103 is a reply to message #213887] Sun, 14 January 2007 23:46 Go to previous message
DrNeko
Messages: 17
Registered: January 2007
Location: NJ
Junior Member
Thanks!
Previous Topic: Restoration, Recovery of database from another server backup
Next Topic: backup archivelog keep forever
Goto Forum:
  


Current Time: Sun Dec 04 16:33:24 CST 2016

Total time taken to generate the page: 0.15686 seconds