| user privs [message #125096] |
Thu, 23 June 2005 05:03  |
Zakkhalid
Messages: 47
Registered: April 2005
|
Member |
|
|
Hi,
I have a number of users that permissions on tables owned by another user.. so jo,fred and tom have synonyms to tables owned by jane. The boys can do selects, update etc; but I don't which one can do what to the tables, and which tables.
Had a look at user_role_privs with no success..
thanking you all inadvance...
|
|
|
|
| Re: user privs [message #125097 is a reply to message #125096] |
Thu, 23 June 2005 05:19  |
munishmsh
Messages: 15
Registered: May 2005
Location: Bangalore
|
Junior Member |
|
|
If its 10g DB, then there is a table "table_privileges" which will give you all the privileges on the particular table.
Hope that it willhelp. Just let me know in case you want somethign else.
Rgds,
Munish
|
|
|
|
| Re: user privs [message #125101 is a reply to message #125097] |
Thu, 23 June 2005 05:29 |
Zakkhalid
Messages: 47
Registered: April 2005
|
Member |
|
|
Hi,
Thanks for the prompt response.. sorry I should have said I was on 9.2 ...
however I did find the table, and it has proved to very helpful, so thank you very much !!!
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
