| electronic |
Posted: May 30, 2007 08:20:08 AM |
Total Post: 21
Joined: Feb, 2007
|
I would like to know because when creating a done on a chart of an user with system he/she gives me insufficient privileges. As this it is possible if the user system has the ROL dba and the rol dba has the privilege select any table?
Example:
create view cust_view as
select *
from emi.customers;
Error at line 3:
ORA-01031: insufficient privileges
|
|
|
 Ratnaker |
| Posted: May 31, 2007 03:41:54 AM |  |
|
Total Post: 136
Joined: Apr, 2007
|
Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.
Ratnaker
|
|
|
|
|
| electronic |
| Posted: Jun 04, 2007 01:54:07 AM | |
|
Total Post: 21
Joined: Feb, 2007
|
I already commented it to the dba and he/she told me that it could be because system doesn't have the privilege of select any table but I look at it and I saw that I eat system he/she has the list since dba he/she also has the privilege of systems select any table for what I see that this it is not the reason for what gives this error.
Can somebody tell me because he/she gives this error if system has the list dba?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
