Re: grant rights to a role

"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