Re: Restricting CREATE priviliges

jshiruru_at_att.com wrote in article <853180401.9788_at_dejanews.com>...
> Hi all,
>
> Is it possible to restrict CREATE/DROP priviliges to only certain type
> of operations ?
> For example: A programmer may not have permissions to CREATE/DROP tables
> or views, however, he/she might want to CREATE stored
 procedures/triggers.
> Is there a way where one can be granted CREATE permissions for stored
> procedures but not tables ?
>
> Thanks for any help
>
> Jagdeep
> jshiruru_at_att.com
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>

Use:-
  grant create procedure to xxxxx;
  revoke create table from xxxxx;
etc...

Ian
ianl_at_kcbbs.gen.nz Received on Fri Jan 17 1997 - 00:00:00 CET