ORA-01031: insufficient privileges

[beksalur]

when i connect to db with a connect and resource roles granted to this user and select users' view has dba role i got the ORA-01031: insufficient privileges error.

i also grant the select permission the tables under this view and the view itself.

but still get this error.
what can i do?

Thanks in advance.

Serdar CAN

 

[sem]

Can you explain a bit more calmly what you do and what you get? The only thing I understood is that you got this error

Regards, Dima

http://seminihin.narod.ru

 

[THoey]

What tool and version are you trying to connect with? If it is Enterprise Manager Console, you also need the SELECT_CATALOG_ROLE.

Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[SantaMufasa]

Beksalur,

A frequent cause of "ORA-01031: insufficient privileges error" is when you are trying to effect a DBA-level command or program, but are logged into the operating system with an o/s account that is not a member of the o/s-known DBA group.

To determine the o/s "group" to which a login must be a member to avoid "ORA-01031":
On Unix, first look at the contents of the "config.s" file:
$ cd $ORACLE_HOME/rdbms/lib
$ tail -10 config.s
.L12:
/* 0x0008 15 */ .ascii "dba\0"
/* 0x0014 20 */ .align 8


.L13:
/* 0x0014 22 */ .ascii "dba\0"

Notice that "dba..." appears following the ".ascii" entries. This means that an authorised DBA (from the o/s perspective) must be a member of the o/s group, "dba".

To then confirm the group membership of a specific o/s user (on Solaris, for example):
$ id -a <username>
For example:
$ id -a dhunt
uid=10177(dhunt) gid=40(keytex) groups=1417(mysql)
** Notice that "dhunt" is not a member of the "dba" group.
$ id -a oracle
uid=10034(oracle) gid=105(oracle) groups=105(oracle),104(dba)
** Notice that the "oracle" login IS a member of both the "oracle" group and the "dba" group.

(on Windows2000, for example):
First, you must connect to Windows as a user with "administrator" rights for that machine.
Then, <right-click>My Computer..Manage..<right-click>Computer management..Action..Connect to another computer (Enter target computer name)..System Tools..Local Users and Groups..Groups, click [ORA_DBA] to see the names of Windows users that have permission to use Oracle DBA-level software.

Let us know if these o/s-permission issues are at the root of your "ORA-01031" problems.

Mufasa
(aka Dave of Sandy, Utah, USA @ 17:20 (27Feb04) UTC (aka "GMT" and "Zulu"), 10:20 (27Feb04) Mountain Time)

 

[beksalur]

we are not using OS authentication but oracle password file for client connections(we run oracle on redhat advanced server v2.1).The problem is;
when a user wants to select a view from another users' schema (but this user has dba role) gets ORA-01031 error.

i give the select permission to the user on this view and the tables under this view.

 

[BJCooperIT]

Unless you have created a synonym for user XXX's view, when user YYY wants to access that view it must be prefixed by the schema name:

select * from XXX.VIEWNAME;

Could this be your problem?

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant/Custom Forms & PL/SQL - Oracle 8i & 9i - Windows 2000