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

Home -> Community -> Usenet -> c.d.o.misc -> Re: grant rights to a role

Re: grant rights to a role

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 22 Nov 2004 06:37:28 -0500
Message-ID: <vIidnRUuhLHmUjzcRVn-rA@comcast.com>

"Mike Stiller" <donotanswer_at_web.com> wrote in message news:30dnftF2ughj7U1_at_uni-berlin.de...
| Is it possible, to grant rights to a role
| for changing and dropping table on a definied user ?
|
|

look into

grant drop any table (cannot be restricted to just one table or user, you'd have to write a wrapper package for that)

grant alter on xxx to xxxx (on a per-table basis)

++ mcs Received on Mon Nov 22 2004 - 05:37:28 CST

Original text of this message

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