Can groups be set up within SQL Server 2000?

We would like to create groups (like Windows OS Groups) strictly within SQL
Server. This would give us easier control over permissions of groups SQL
Server login accounts. Then we wouldn't have to maintain permissions on
many, many individual SQL Server logins.
I realize that we could give the same users permissions through Windows
"Local Users and Groups", but our current goal is to not give them Windows
user accounts--just SQL Server permissions.
Any ideas?
Thanks!
JimYou cannot create groups at the server level but you can at the DB level.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Jim Moon" <please.reply@.group> wrote in message
news:uSBRYp8FGHA.3864@.tk2msftngp13.phx.gbl...
We would like to create groups (like Windows OS Groups) strictly within SQL
Server. This would give us easier control over permissions of groups SQL
Server login accounts. Then we wouldn't have to maintain permissions on
many, many individual SQL Server logins.
I realize that we could give the same users permissions through Windows
"Local Users and Groups", but our current goal is to not give them Windows
user accounts--just SQL Server permissions.
Any ideas?
Thanks!
Jim|||I see what you mean--create a role, add user(s) to that role, and assign
permission on database objects.
Thank you, Tom!
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ejpLPG9FGHA.2040@.TK2MSFTNGP14.phx.gbl...
> You cannot create groups at the server level but you can at the DB level.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Jim Moon" <please.reply@.group> wrote in message
> news:uSBRYp8FGHA.3864@.tk2msftngp13.phx.gbl...
> We would like to create groups (like Windows OS Groups) strictly within
> SQL
> Server. This would give us easier control over permissions of groups SQL
> Server login accounts. Then we wouldn't have to maintain permissions on
> many, many individual SQL Server logins.
> I realize that we could give the same users permissions through Windows
> "Local Users and Groups", but our current goal is to not give them Windows
> user accounts--just SQL Server permissions.
> Any ideas?
> Thanks!
> Jim
>
>|||As long as it's a database role, yes.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Jim Moon" <please.reply@.group> wrote in message
news:ezNEXM9FGHA.3080@.TK2MSFTNGP10.phx.gbl...
I see what you mean--create a role, add user(s) to that role, and assign
permission on database objects.
Thank you, Tom!
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ejpLPG9FGHA.2040@.TK2MSFTNGP14.phx.gbl...
> You cannot create groups at the server level but you can at the DB level.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Jim Moon" <please.reply@.group> wrote in message
> news:uSBRYp8FGHA.3864@.tk2msftngp13.phx.gbl...
> We would like to create groups (like Windows OS Groups) strictly within
> SQL
> Server. This would give us easier control over permissions of groups SQL
> Server login accounts. Then we wouldn't have to maintain permissions on
> many, many individual SQL Server logins.
> I realize that we could give the same users permissions through Windows
> "Local Users and Groups", but our current goal is to not give them Windows
> user accounts--just SQL Server permissions.
> Any ideas?
> Thanks!
> Jim
>
>