Re: Grants for Views

From: Anthony Hogan <anon_at_spain.es>
Date: Wed, 22 May 2002 13:23:27 +0000
Message-ID: <3CEB9BCF.4E65D44E@spain.es>

Sure - REVOKE CREATE VIEW FROM user;
This will work if the create view privilege has been explicitly granted. If the user has been granted the CONNECT and RESOURCE roles you will have to revoke the roles, grant create session to user and work up from there.

hth
Anthony Hogan
ahogan-nospam-_at_iespana.es

susi sorglos wrote:
>
> Hello
>
> Is it possible for a DBA to revoke the right of a user to create views in
> his own schema?
>
> Thanks a lot
> Fabienne
Received on Wed May 22 2002 - 08:23:27 CDT