April 5, 2006 at 7:19 am
Hello there,
I don't know what exactly I'm doing wrong here. I have a database in which I have just added a user. By clicking on its properties I can to navigate to tables, select a few tables and then give these tables permissions. However this is just not working how I expect it to. Can anyone explain how to give a user for a certain database different rights for different tables?
Thanks in advance
April 6, 2006 at 7:58 am
What do you mean by “However this is just not working how I expect it to”? What is it that you expect?
You can GRANT permission to a user that you add. Alternatively, you can group users whom you want to give the same access rights to your database and then create a ROLE for them. In short, a role is a collection of users with the same access rights. Take a look at GRANT and Roles in BOL.
April 6, 2006 at 8:07 am
Ok thanks for that. I think I was a getting a little confused as
I wasn't alway using the system adminstrator to administrate users etc. This I think was the reason why despite my efforts alterations to the database weren't taking effect. Maybe this is quite obvious but I'm very new to sql server.
Thanks for your comments I will keep them in mind.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply