Home » RDBMS Server » Server Administration » grant ,option with grant (oracle 10g)
grant ,option with grant [message #498897] |
Fri, 11 March 2011 15:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ykozhevnikov
Messages: 59 Registered: November 2008 Location: USA
|
Member |
|
|
Hi
I am new in Oracle administration
This is what happend
I was acting as SYSTEM user and
I was not able to give grant on select on my_view to particular user in Oracle and error mention particular table in view
But after I put
GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON <my_particulat_table> TO <another_user> with grant option
SYSTEM user was able to grant .
And my question is I did change anything for SYSTEM, Why it was able to create grant
Thanks
[Updated on: Fri, 11 March 2011 15:42] Report message to a moderator
|
|
|
Re: grant ,option with grant [message #498919 is a reply to message #498897] |
Fri, 11 March 2011 21:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136607.jpg) |
ramoradba
Messages: 2456 Registered: January 2009 Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
SQL> GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON scott.emp to hr with grant option;
Grant succeeded.
SQL> GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON scott.emp to hr ;
Grant succeeded.
SQL> create or replace view scott.emp_vue as select * from scott.emp;
View created.
SQL> GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON scott.emp_vue to hr;
GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON scott.emp_vue to hr
*
ERROR at line 1:
ORA-02204: ALTER, INDEX and EXECUTE not allowed for views
SQL> GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON scott.emp to hr with grant option;
Grant succeeded.
SQL> ! oerr ora 2204
02204, 00000, "ALTER, INDEX and EXECUTE not allowed for views"
// *Cause: An attempt was made to grant or revoke an invalid privilege on a view.
// *Action: Do not attempt to grant or revoke any of ALTER, INDEX, or
// EXECUTE privileges on views.
SQL>
SQL> show user
USER is "SYSTEM"
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
Sriram
|
|
|
|
|
Goto Forum:
Current Time: Tue Sep 10 06:01:36 CDT 2024
|