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: GRANTing priveleges to a user?

Re: GRANTing priveleges to a user?

From: michael ngong <mngong_at_yahoo.com>
Date: 12 Feb 2002 07:50:32 -0800
Message-ID: <ecf365d5.0202120750.46bad25c@posting.google.com>


akshaysalkar_at_joymail.com (DukeNM) wrote in message news:<f987cd53.0202120330.25ca7f2a_at_posting.google.com>...
> What does this do?
> GRANT INSERT, UPDATE, DELETE, SELECT
> ON customers
> TO lellison;
>
> i am currently in the user/schema practice09.

This will grant the rights specified to lellison If you own those tables or have select rights with grant option on them If not even as sysdba you will not be able to grant select to someone else's tables Michael Ngong(Sr DBA) Received on Tue Feb 12 2002 - 09:50:32 CST

Original text of this message

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