CODEWITHSUNDEEP
oracle11g
b.sabarathinam saba
b.sabarathinam saba

Reputation: 103

Unable to access user_tables table in oracle

I am new to oracle. I have created the user axsaum in DB and logged in as the same user. When I try to access select * from user_tables or dba_tables its throwing error as table not exist Please suggest me why i dont have privilege to access default tables? how to access those?

SQL> select * from user_tables;
     * ERROR at line 1: ORA-00942: table or view does not exist


SQL> select * from dba_tables;
     * ERROR at line 1: ORA-00942: table or view does not exist

Upvotes: 0

Views: 1180

Answers (1)

v8-E
v8-E

Reputation: 1105

I think you need to give previliages to newly created user you can use grant for giving permission to user once permission given you can see tables as well as can perfrom DML and DDL on DB

for gratting previliages

for all permissions you can use

GRANT DBA TO axsaum ;

For other permissions you use below

GRANT CONNECT TO axsaum ;

GRANT SELECT ANY TABLE to axsaum is a system privilege grant that allows user to select from any Table or View.

GRANT SELECT on some_table to axsaum is an object privilege grant that allows user to select from Table.

GRANT SELECT, UPDATE ON some_table TO axsaum;

Upvotes: 1

Related Questions