By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

SQL 7.0 Stored Procedure Execute Privileges Only?

P: n/a
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
Apr 14 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Apr 15 '06 #2

P: n/a
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

Apr 16 '06 #3

P: n/a
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

Apr 19 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.