| Parameter & Performance Views [message #182595] |
Mon, 17 July 2006 04:03  |
ehegagoka
Messages: 493
Registered: July 2005
|
Senior Member |
|
|
hi!
i have an ordinary user in my test dbase, 10g XE, it has no much access, whenever i need to see some performance views like v$parameter i need to connect to the dba user i've created, also other tables like dba_tablespaces...etc..is it really restricted? how can i make my ordinary user also see the views by dba? or is not advisable? also the command show parameter wont work.
thank you so much sir/mam =)
[Updated on: Mon, 17 July 2006 04:17] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Parameter & Performance Views [message #182773 is a reply to message #182734] |
Tue, 18 July 2006 02:46  |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
select * from dict_columns where column_name like '%PRIV%'
will show you all tables that have columns with 'PRIV' (i.e. priviledges) in the name. This will show you the tables that you need to look at for priviledge info.
Jim
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
