SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 07:07 PM
| ||||
| ||||
 SQL 7.0 Stored Procedure Execute Privileges Only? 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      |
|
02-29-2008, 07:07 PM
| |||
| |||
| Re: SQL 7.0 Stored Procedure Execute Privileges Only? Hi Ed Check out the GRANT command in Books Online. John "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 > > |
|
02-29-2008, 07:07 PM
| |||
| |||
| Re: SQL 7.0 Stored Procedure Execute Privileges Only? 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 > > |
|
02-29-2008, 07:09 PM
| ||||
| ||||
| Re: SQL 7.0 Stored Procedure Execute Privileges Only? 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 |
 |
« delete sql syntax for linked notes table
|
[ANNOUNCE] Document XQuery with Stylus Studio and xqDoc »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:53 PM.
