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


.

Relevant Pages

  • Re: Cant view reg key HKLMSWMSWindowsCurrentVersion
    ... Yes, we checked all of the permissions, but were unable to propogate them to ... A reboot fixed the problem completely. ... Microsoft MVP: Windows Server ... database server running SQL 2000. ...
    (microsoft.public.windows.server.general)
  • Re: error while creating the portal....error log is here
    ... Is SQL, does the user himal.com\administrator have the proper SQL ... > in configuration database. ... Windows NT user or group ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SQL CE Synching Problems
    ... Have you granted IUSER_ServerName access to your publication within SQL ... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.programming)