S.Balasubramanian
Thursday, July 10, 2008
Create Role and Assign the user to the role
To Create a Role:
Create Role [role_name]
Responsibilities to the Role:
Grant Execute on sp_name to [role_name]
Grant select,insert,update,delete on table_name to role_name
Assign the user to the role:
exec sp_addrolemember N'role_name', N'login_name'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Search This Blog
Blog Archive
►
2010
(5)
►
July
(3)
►
May
(1)
►
April
(1)
►
2009
(7)
►
August
(1)
►
July
(2)
►
May
(1)
►
April
(1)
►
March
(1)
►
January
(1)
▼
2008
(22)
►
December
(8)
►
November
(1)
►
October
(7)
▼
July
(6)
Set Primary Key and Foreign Key to Table using SQL...
Backup Database using C#.net
Backup Database SQL SERVER 2005 Query
Get all SP and Tables and Views from the Database
Create Role and Assign the user to the role
Create Login and user in SQL Server 2005
About Me
S.Balasubramanian
View my complete profile
My Blog List
S.Vinothkumar
Take ASP.NET application to offline
11 years ago
Shaalini
Charts in Silverlight
14 years ago
No comments:
Post a Comment