SQL 7.0 Stored Procedure Execute Privileges Only?

[Edbar]

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

[John Bell]

Hi Ed

Check out the GRANT command in Books Online.

John

"Edbar" <ed***@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

[Jack Vamvas]

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" <ed***@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

[Ajay Rengunthwar]

If you are looking to restrict access through application You can think
of.....
Application role, which allows you to create a role for your
application and grant only this role the proper rights. This role
requires a separate password authentication before granting the rights
associated with the role. So, the user can log in with his own ID and
password. Make sure in your application, you use the sp_setapprole with
a password that only you and your application know to activate the
proper rights. Although the user will be able to log in to SQL Server
through another tool, he will not be able to access without knowing the
password for the application role.

Hope this helps.

Thanks
Ajay Rengunthwar
MCDBA,MCAD