Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

permissions Expand / Collapse
Author
Message
Posted Monday, September 21, 2009 12:17 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
how to provide the execute permissions to the stored procedures and select, update, delete rights on the tables to a perticular user?
Post #790952
Posted Monday, September 21, 2009 12:36 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 15, 2014 5:22 AM
Points: 2,728, Visits: 1,119
charipg (9/21/2009)
how to provide the execute permissions to the stored procedures and select, update, delete rights on the tables to a perticular user?


As mentioned before in previous posts.

GRANT EXECUTE to [loginname]

will give execute permissions for procedures for that particular database.

as for DML Permissions

it is better to do that at object level so,

GRANT SELECT on [tablename] to [username]
GRANT DELETE on [tablename] to [username]
GRANT INSERT on [tablename] to [username]


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #790956
Posted Monday, September 21, 2009 12:40 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
5oo tables are present in that db.
so at a time how to give the permissions.?
Post #790958
Posted Monday, September 21, 2009 12:41 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
i want to give these permissions to all tables.
Post #790959
Posted Monday, September 21, 2009 12:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 15, 2014 5:22 AM
Points: 2,728, Visits: 1,119
There are better ways of doing it but

USE [databasename]
GO
GRANT SELECT TO [username]

try that and let me know if that works for you.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #790964
Posted Monday, September 21, 2009 12:54 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
its not working.
Post #790967
Posted Monday, September 21, 2009 12:57 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 15, 2014 5:22 AM
Points: 2,728, Visits: 1,119
how did you test it, remember that allocating permissions this way, it will not show correctly in the GUI. but the permissions would have been allocated

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #790969
Posted Monday, September 21, 2009 1:03 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
yes, i cheked in GUI after excuting that query.
Post #790972
Posted Monday, September 21, 2009 1:04 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 15, 2014 5:22 AM
Points: 2,728, Visits: 1,119
If you right click on the database select properties, look at permissions. you will see the user that you granted the select permission to.

if you click on that user, then click on effective, you will see select there. as well as if yo8u click on explicit, scroll down to select and you will see grant is ticked.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #790973
Posted Monday, September 21, 2009 1:55 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
thanks........i got it........
Post #790981
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse