|
|
|
|
|
|
|
|
|
|
| Re: How to check grant privs own by user [message #514183 is a reply to message #513577] |
Sat, 02 July 2011 05:50  |
 |
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
|
Senior Member |
|
|
balaji if i think correct you want to give all priv on tab1 table to public
the correct syntax is here
SQL> grant all on tab1 to public;
Grant succeeded.
SQL>
and balaji if tab1 is your table so you have all privilage you can grant and if tab1 is not in your schema so a user give you a priv with grant option so you have rights to give priv on this table
look this example here sh1 table in scott user so scott has full priv on his sh1 table so he give object to hr user with grant option after that hr has full priv on scott sh1 table to give priv on sh1 object to any user look below this exaple
=================================================================
SQL> conn scott/tiger
Connected.
SQL>
SQL>
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT TABLE
EMP TABLE
BONUS TABLE
SALGRADE TABLE
RJ1 TABLE
TEST TABLE
SH1 TABLE
DP TABLE
FGA_TEST TABLE
9 rows selected.
SQL> grant all on sh1 to hr with grant option;
Grant succeeded.
SQL> conn hr/hr
Connected.
SQL>
SQL>
SQL> grant all on scott.sh1 to public;
Grant succeeded.
SQL>
[Updated on: Sat, 02 July 2011 06:05] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
