OraFAQ Forum: Backup & Recovery » How to create script of a user/role definition

Home » RDBMS Server » Backup & Recovery » How to create script of a user/role definition

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to create script of a user/role definition [message #213878]

Fri, 12 January 2007 11:04

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.

Report message to a moderator

Re: How to create script of a user/role definition [message #213887 is a reply to message #213878]

Fri, 12 January 2007 12:08

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: How to create script of a user/role definition [message #214103 is a reply to message #213887]

Sun, 14 January 2007 23:46

DrNeko
Messages: 17
Registered: January 2007
Location: NJ

Junior Member

Thanks!

Report message to a moderator

Previous Topic:	Restoration, Recovery of database from another server backup
Next Topic:	backup archivelog keep forever

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 00:59:16 CDT 2024