OraFAQ Forum: Server Administration » ORA-04043 resulting while quering user

Home » RDBMS Server » Server Administration » ORA-04043 resulting while quering user_views

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

ORA-04043 resulting while quering user_views [message #144346]

Wed, 26 October 2005 03:20

ghosh_shibaji
Messages: 8
Registered: February 2005
Location: Kolkata

Junior Member

Hi,

My DBA has created an user account for me in Oracle 9i database. He confirmed that he has given only the create session privilege to me. No other system privilege given. However, after successful login with that account id, I am not able to query any of the user_views tables. Even the "select * from tab" not working. I am getting the error "ORA-04043 : Insufficient privileges" every time. select * from session_privs shows only "CREATE SESSION". Other users can perform queries on user_views.

I tried in my Dev db by creating an user account and granting only the "CREATE SESSION" privilege. However, I am able to query the user_views as well as select * from tab also working.

If anyone can help me out in finding what privilege is missing or what do I need to do to get the things moving.

Thanks in advance.

Report message to a moderator

Re: ORA-04043 resulting while quering user_views [message #144347 is a reply to message #144346]

Wed, 26 October 2005 03:35

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Since only "Create Session" privilege is granted, you can only connect to database & can't do anything else.
You need select privileges for querying purpose.
Ask your dba to grant you select privilge on all/desired objects.

--Girish

Report message to a moderator

Re: ORA-04043 resulting while quering user_views [message #144349 is a reply to message #144347]

Wed, 26 October 2005 03:43

ghosh_shibaji
Messages: 8
Registered: February 2005
Location: Kolkata

Junior Member

Thank you for the response.

You are right. I also guessed that way. However, as I have mentioned that I have created a user in my dev box and granted only the "create session" privilege to that account. But to my surprise I was able to query the user_views as well as the select * from tab working. To be more sure I queried the "select * from session_privs", it says only CREATE SESSION. no other privileges given.

Are there any more areas I can check ?

Report message to a moderator

Re: ORA-04043 resulting while quering user_views [message #144366 is a reply to message #144349]

Wed, 26 October 2005 04:46

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

These user_views, session_privs etc are some dictionary views which are associated with every oracle user & can be queried by any logged in user.

Check if you can select any data from any user tabels, create any table, procedure etc there. You wont be able to do these, as you dont have the privileges for doing so.

--Girish

Report message to a moderator

Re: ORA-04043 resulting while quering user_views [message #144755 is a reply to message #144366]

Fri, 28 October 2005 01:54

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi

ghosh ask for grant resource by your DBA to your user in oracle Database .. if he will grant that you will be able to work as developer ... Very Happy