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.

Quote:

Originally Posted by mknoll217

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.