|
|
Posted by Jack Vamvas on 04/16/06 10:16
Yes, you can eitther do it through Enterprise Manager or use
GRANT EXECUTE on mySp TO PUBLIC (or whatever user )
there is also a DENY
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Edbar" <edbar@exmsft.com> wrote in message
news:FpT%f.1351$pi6.576@dukeread12...
> SQL 7.0 Stored Procedure Execute Privileges Only?
>
> Does anyone know if a user/pass can be set up to give
> a sql 7.0 user stored procedure execute privileges only.
>
> That way, even if they get into the database, they can
> do nothing except run the stored procedures.
>
> Thanks,
> Ed
>
>
Navigation:
[Reply to this message]
|