RE: use TOAD to check user privileges

You can generate the script to create the user which will include all the privileges.

Danut Bancea
Tel: 416 643 1631

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David Sent: June 13, 2012 11:17 AM
To: 'mccdba1_at_yahoo.com'; 'oracle-l_at_freelists.org' Cc: 'oracle-db-l_at_Groups.ITtoolbox.com' Subject: RE: use TOAD to check user privileges

Try desc username :)

(you may have to use double quotes around username depending on the structure)

Works in Toad 11 and 11.5 (not sure about previous versions)

Chris Taylor

"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)

Any views and/or opinions expressed herein are my own and do not necessarily reflect the views of Ingram Industries, its affiliates, its subsidiaries or its employees.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Wednesday, June 13, 2012 10:15 AM
To: oracle-l_at_freelists.org
Cc: oracle-db-l_at_Groups.ITtoolbox.com
Subject: use TOAD to check user privileges

Can anyone tell me how to use TOAD to check user's system and object privileges?

Thanks.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 13 2012 - 10:20:51 CDT