How to create script of a user/role

Expand Post »

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.

Similar Threads

I want to create a community script in PHP
Learning PHP but problem with script in PHP
script to call google search? in Perl
ftp and compare script in Shell Scripting
help with script in PHP

53050373

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Mar 2007

Permalink

Aug 23rd, 2007

Re: How to create script of a user/role

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.

Musta

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Oracle Forum Timeline: Question

Next Thread in Oracle Forum Timeline: Differences between versions of oracle

DaniWeb Message

Cancel Changes

User Name
Password