470,596 Members | 1,613 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

Permissions and Users in SQL Server 2005

I have never had to create permissions in SQL Server before. I'm not sure what to do or even where to start. I have tried to look around the internet to find out how to do it. No one has it simply explained that I could find at least. Any help on how to create the Users and the Permissions would be greatly appreciated. Thanks. I think I could figure out how to do the permissions if only it had any more users than guest.
Jun 26 '07 #1
1 1416
I have never had to create permissions in SQL Server before. I'm not sure what to do or even where to start. I have tried to look around the internet to find out how to do it. No one has it simply explained that I could find at least. Any help on how to create the Users and the Permissions would be greatly appreciated. Thanks. I think I could figure out how to do the permissions if only it had any more users than guest.
You can grant permissions to a user Like:

GRANT SELECT,INSERT, UPDATE,DELETE ON sales to mknoll217
GRANT CREATE ANY DATABASE to mknoll217
GRANT ALTER TRACE TO mknoll217
and so on...

It's probably best to create ROLES that define a set of permissions you can grant to a user.
Jun 28 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by BingoHandJob | last post: by
10 posts views Thread by Shelly | last post: by
reply views Thread by Fran Tirimo | last post: by
2 posts views Thread by dimstthomas | last post: by
3 posts views Thread by Alex Maghen | last post: by
9 posts views Thread by Nemisis | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.