Member Avatar for 53050373

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.

  • 2 Contributors
  • 1 Reply
  • 180 Views
  • 5 Months Discussion Span
  • Latest Post Latest Post by Musta
Member Avatar for Musta

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.