Re: grant-syntax

From: Richard Armstrong <StateOArt_at_worldnet.att.net>
Date: Thu, 3 Jun 1999 13:03:46 -0600
Message-ID: <7j6jdo$ngj$1@bgtnsc01.worldnet.att.net>

You can revoke system privileges and/or roles using either the revoke system privileges/roles dialog box of Enterprise Manager or the SQL command REVOKE.

REVOKE [privilege], [role] from [user];

You can revoke object privileges using Enterprise Manager or the SQL command REVOKE. To revoke an object privilege, the revoker must be the original grantor of the object privilege being revoked.

REVOKE [privilege], [privilege] ON [tablename] FROM [user], [user];

REVOKE ALL ON [tablename] FROM [role];

--

---

Richard Armstrong
State Of The Art Consulting, Inc.
http://www.stateoart.com

---

gnome <gnome_at_uskla.se> wrote in message news:37561AB2.E274A97B_at_uskla.se...
> Hello
>
> Does anybody know syntax of removing all grants from
> a table?
> revoke..??.tablename.??
>
> Regards,
> Gnome
Received on Thu Jun 03 1999 - 14:03:46 CDT