OraFAQ Forum: Security » show parameter db_name

Home » RDBMS Server » Security » show parameter db_name - Table or view does not exist

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

show parameter db_name - Table or view does not exist [message #228484]

Tue, 03 April 2007 03:40

smora
Messages: 59
Registered: May 2006

Member

Hi

Im running Oracle 10g on live and dev.

On dev:
I created the database
Created a user 'x'
Granted all privileges to 'x'

When I logged in as the user 'x' and tried to run 'show parameter db_name' it gave me an error saying 'Table or view does not exist'. However, running the command as sysdba gave the correct value for db_name.

I then did a full export from live to dev, and after the import on dev i am able to see the db_name while logged in as 'x'.

My questions are: What changed during the export to allow me to see the paramters? Can i set it manually?

Thanks
smora

Report message to a moderator

Re: show parameter db_name - Table or view does not exist [message #228490 is a reply to message #228484]

Tue, 03 April 2007 03:54

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

On dev user "X" don't have "dba" or "select any dictionary" privs.
that is why user "X" cann't able to see "db_name" parameters.
if you want to see dbname use below query

select * from global_name;

When your import your "X" user from PRODUCTION then that time USER "X" having sufficient privs to see "db_name" parameter.

regards
Taj

Report message to a moderator

Re: show parameter db_name - Table or view does not exist [message #228519 is a reply to message #228490]

Tue, 03 April 2007 04:58

smora
Messages: 59
Registered: May 2006

Member

Taj

I granted all privileges to user 'x' when i created it, using:

grant all privileges to x

Why would that not grant the 'select any dictionary' privilege to x?

Report message to a moderator

Re: show parameter db_name - Table or view does not exist [message #228604 is a reply to message #228519]

Tue, 03 April 2007 08:08

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
'select any dictionary'
You should grant manually or grant DBA privs.
"ALL" privs is object level privs.
and "select any dictionary" is system privs.

SQL> create user od identified by od;

User created.

SQL> grant all privileges to od;

Grant succeeded.

SQL> conn od/od
Connected.
SQL> select privilege
  2  from session_privs
  3  where privilege = 'SELECT ANY DICTIONARY';

no rows selected

Report message to a moderator

Previous Topic:	external_name from dba_users
Next Topic:	Deleting a User entry from OID using dbms_ldap

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 08:54:50 CST 2024