Home » RDBMS Server » Security » show parameter db_name - Table or view does not exist
show parameter db_name - Table or view does not exist [message #228484] Tue, 03 April 2007 03:40 Go to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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?
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 Go to previous message
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



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


Current Time: Thu Mar 28 12:49:04 CDT 2024