User rights

[inungh]

I need create new users. I just wonder does SQL server 2000 support
user group, for example, I can assign admin, manager and supervisros
groups for the users for the rights that I do not give any individual
rights.


Your information is great appreciated,

[Erland Sommarskog]

Post by inungh
I need create new users. I just wonder does SQL server 2000 support
user group, for example, I can assign admin, manager and supervisros
groups for the users for the rights that I do not give any individual
rights.

Yes, you can create groups in your database, although they are called
roles. You use sp_addrole to create a group and sp_addrolemember to add
a user to that group.-

[iccsi]

Thanks millions,
Can I use Enterprise Manager to add Role and memebers without running
system stored procedures?

Thanks again,

Post by Erland Sommarskog

Post by inungh
I need create new users. I just wonder does SQL server 2000 support
user group, for example, I can assign admin, manager and supervisros
groups for the users for the rights that I do not give any individual
rights.

Yes, you can create groups in your database, although they are called
roles. You use sp_addrole to create a group and sp_addrolemember to add
a user to that group.-
--
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

[Erland Sommarskog]

Post by iccsi
Can I use Enterprise Manager to add Role and memebers without running
system stored procedures?

You can use EM, but not without running system procedures, because that
is what EM runs.

[iccsi]

Thanks for the message and helping,
Once I added the role in the database.
How can I add the rights to certain tables or columns?

Your help is great appreciated,

Post by Erland Sommarskog

Post by iccsi
Can I use Enterprise Manager to add Role and memebers without running
system stored procedures?

You can use EM, but not without running system procedures, because that
is what EM runs.
--
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Erland Sommarskog]

Post by iccsi
Thanks for the message and helping,
Once I added the role in the database.
How can I add the rights to certain tables or columns?

For instance:

GRANT SELECT ON tbl TO yourrole

This grants SELECT on columns in the table. Normally you don't mess
with permissions on columns, but if you have sensitive data you can
explicitly deny access to a certain column. I don't remember the syntax
on the top of my head, but Books Online has the information.