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: privilege question

Re: privilege question

From: Roel Toledo <dontsendmailstome_at_bogusmail.com>
Date: Mon, 29 Oct 2001 21:37:33 GMT
Message-ID: <x_jD7.146238$3d2.5013249@bgtnsc06-news.ops.worldnet.att.net> 





> Only the owner of the object can grant privileges, unless he granted the

> privileges to someone else 'with admin option'





Aha!  I got the "senior" Oracle DBA wrong here.  :-)



It is supposed to be "with grant option" instead of "with admin option" in
your statement.



WITH ADMIN OPTION is for system privileges while WITH GRANT OPTION is for
object privileges.



Roel Toledo


(Non Senior) Oracle DBA
Received on Mon Oct 29 2001 - 15:37:33 CST












Original text of this message













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