Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Grant privileges using SYS user.......
Hi,
Only owner can grant privileges on his objects. If they are granted with admin option then they can be regranted by another user.
Andrew Protasov
>
> Hi,
>
> I use SYS user and execute a SQL command 'GRANT ALL ON user1.my_table TO
> user2' in SQL*Plus, but respond 'no privileges to GRANT'. I'm sure it
> own all system privileges of DBA role. Why SYS can't GRANT one's table
> to another ??
>
>
>
>
>
Received on Wed Nov 25 1998 - 04:04:06 CST