Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Grant privileges using SYS user.......

Re: Grant privileges using SYS user.......

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Wed, 25 Nov 98 12:04:06 +0200
Message-ID: <AFMOzMsK42@protasov.kiev.ua>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US