Groups and Permissions question

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.

re: Groups and Permissions question

Bob C. (bcanavan@bmghomes.com) writes:[color=blue]
> 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?[/color]

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, sommar@algonet.se

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

re: Groups and Permissions question

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