| View the priviledges of a user/account [message #16582] |
Fri, 03 December 2004 07:01  |
pirya
Messages: 1
Registered: December 2004
|
Junior Member |
|
|
I want to view what priviledges a certain account has... How do I do that ? Like if the account can create tables, access tables, create stored procedures, etc..
Is this possible?
|
|
|
|
|
|
|
|
| Re: View the priviledges of a user/account [message #172363 is a reply to message #172116] |
Tue, 16 May 2006 03:43  |
kmsalih
Messages: 197
Registered: March 2006
|
Senior Member |
|
|
I think the below example will help you.
SQL>CONN / AS SYSDBA
SQL>GRANT EXECUTE ON DBMS_METADATA TO SCOTT;
SQL>CONN SCOTT/TIGER
SQL>SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','SCOTT') from dual;
The above sql will list all the object grants . Also includes packages procedures ).
Regards
Salih Km
|
|
|
|
| Re: View the priviledges of a user/account [message #172373 is a reply to message #16582] |
Tue, 16 May 2006 04:20 |
ehegagoka
Messages: 493
Registered: July 2005
|
Senior Member |
|
|
hi!
thanks for the reply, i'm using a dba user on a test db, but im getting an error sir,
frgt_uat@foscopy> /
SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','FRGT_UAT') from dual
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
LPX-00210: expected '<' instead of 'n'
ORA-06512: at "SYS.UTL_XML", line 0
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3296
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4148
ORA-06512: at "SYS.DBMS_METADATA", line 458
ORA-06512: at "SYS.DBMS_METADATA", line 615
ORA-06512: at "SYS.DBMS_METADATA", line 1339
ORA-06512: at line 1
frgt_uat@foscopy>
thank you so much =)
|
|
|
|
|
|
|
|
|
|
| Re: View the priviledges of a user/account [message #172496 is a reply to message #16582] |
Tue, 16 May 2006 20:00 |
ehegagoka
Messages: 493
Registered: July 2005
|
Senior Member |
|
|
hi!
hmmm i dont have access to the database, im just connecting from sqlplus, i'll try it at home, whewww...i'm overwhelmed by so many packages to learn, plsql is already a big language, then i also need to learn about database...wheewww will i ever get to learn all of that.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
