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
>
>

Can anyone help with help?

I guess I shouldn't expect Microsoft to go to any trouble to make our lives easier but my goodness they've out done themselves with the latest help system.

Can anyone tell me how to actually find help on anything? I open SQL Server Managment studio and click help How do I and get help on how to use help... Boy how useful... Next I click on search and tell it to search for Autoinc, or increment, and tell it to search products for SQL Server. Boy how nice to bring me all these useful topics on articles written on Fox Pro in the late 90's...

In fact, not a single help entry on SQL Server anywhere in my list... Great!

This is normal. Every search I've done I've had to resort to google. I've even tried turning off this feature to go to the Internet for all the help and its still useless.

All I started out wanting was to find out how to create an AutoInc field type or at least provide that type of feature with SQL Server and 30 minutes later I find myself complaining about help on help!

Is anyone finding this help system with Visual Studio 2005 and SQL Server 2005 even remotely helpful? They should rename it the ConfuseQLater or something...

what i understand from this is u have not installed Books Online (BOL) which is the bible for SQL Server... While installing you should have opted this option ...

download and install BOL from this link...

http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en

Madhu