Groups and Permissions question

[Bob C.]

I am converting a relatively large multi-user Access 97 database to
SQL Server 2000. I use about a dozen groups to manage security,
providing graduated levels of access to each group. I read that in
SQL Server a user can belong to only two groups, "users" and one
other. If this is true, can someone point me in the right direction
as to how I could get around this limitaion?

Thanks,
Bob C.

[Erland Sommarskog]

Bob C. (bc******@bmghomes.com) writes:

I am converting a relatively large multi-user Access 97 database to
SQL Server 2000. I use about a dozen groups to manage security,
providing graduated levels of access to each group. I read that in
SQL Server a user can belong to only two groups, "users" and one
other. If this is true, can someone point me in the right direction
as to how I could get around this limitaion?

Not true. You have have roles and a user can belong to many roles. I
use roles very rarely myself, so I decline to give examples. But the
stored procedures to look at are sp_addrole and sp_addrolememeber.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Bob C.]

Many thanks, Erland! I'll explore the roles approach. -Bob C.