Grants in Management Studio.
-
For the life of me I cannot figure out how to grant select for a table(s) to a user using the SQL Server Management Studio. I see in BOL how to use Transact SQL which if fine but I don't see how it is done in BOL for Mgt studio nor can I figure it out myself... is it that hard or am I just missing something.
-
I think MS made it awkward and difficult to force users into using T-SQL. Which isn't a bad thing necessarily
.In Mgt Studio:
1) Right-click table and select properties.
2) In left-hand pane click permissions.
3) This will display existing permissions
4) In top right-hand pane click on Add if you want to add new user/role permissions.
5) Then click browse to browse users.
6) Add users/roles you want to assign permissions to.
7) Select user and assign permissions
8) Then ask MS if they could have designed something that needed more button clicks
Hope that helps.
-
Unless I am missing something I do not want to grant access to db roles or anything like that... I want to simply get a list of tables in a database and grant select to a group of tables for a user is all. That part I cannot find via this method.
-
Your list of tables is the tables you can see in Mgt Studio. You'd then need to assign permissions to each table individually.
Or you could use T-SQL. Generally, if you want to do something like this on a large scale it's almost always better to use T-SQL.
exec sp_msforeachtable 'grant select on ? to [this_user]'
Hope that helps.
-
OK, I was wrong... I see it now. It is not as straight forward as in 2000. AND there are alot more clicks than before... jeesh.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply