March 4, 2010 at 9:09 am
We have
Server 1 - 3 databases db1,db2,db3
- having same table , say table1,table2,table3,table4,table5,table6....table100
Server 2 - 4 databases db1,db2,db3,db4 - having same table , say table1,table2,table3,table4,table5,table6.....table50
We want to give select,update permission for db1, db2 on table table1,table2....table50 on server1
We want to give select,delete permission for db1, db4 on table table1,table2....table30 on server2
Does anyone has script?
March 10, 2010 at 7:24 am
this is the approach , you can take
use [TestDB]
GO
GRANT SELECT ON [dbo].tablename TO [loginname]
GO
use [TestDB]
GO
GRANT UPDATE ON [dbo].tablename TO [loginname]
GO
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 12, 2010 at 4:44 pm
Take this a step further. Set up roles in your databases. Grant the permissions to the roles. Then add a user to the necessary roles.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 12, 2010 at 10:21 pm
I would set up AD group and grant permission to the group and add users to that group.
March 13, 2010 at 11:43 am
GTR (3/12/2010)
I would set up AD group and grant permission to the group and add users to that group.
And then put that group in a role in SQL Server 😀
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 13, 2010 at 7:48 pm
CirquedeSQLeil (3/13/2010)
GTR (3/12/2010)
I would set up AD group and grant permission to the group and add users to that group.And then put that group in a role in SQL Server 😀
May or may not, i may just give access to DB for that AD group depending on the requirement:-P
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply