Adding logins and permissions

Hot Topic

Connect to SQLExpress via Internet with Windows Authentication?
How Can I use this code for Primary Key autogeneration
Certificate limitations in SQL Server 2005
an error while trying to read .sdf file from the pc application ? please help
Loading multiple files
SQL Server 2005 Express on VISTA
SQLEVN70.rll error
SMS connection
What's magic about DT_STR and size 50
Error converting data type DBTYPE_DBTIMESTAMP to datetime

SQL Server

Shared Datasource Problem
Error in Creating Stored Procedure from VS 2005
SetDefaultInitFields "TextBody" for Stored Procedure
SSIS Package Corruption
Organizing Business Rules in SSIS
date format according to regional setting
Is there a way to set a variable in a data flow from a SQL statement (like in control flow)
SQL 2005 Upgrade Paths
Formatting labels in chart
Separate date and time datatypes - come on guys!

Adding logins and permissions

Hi,
I am at a company with 18 employees and I have 11-12 databases in SQL server. I can't seem to give logins and permissions to groups. Is there a simpler way, or do I have to add every single employee to each database and give permissions


Answer this question

Adding logins and permissions

  • Bryan Yoo

    You may create roles (it's a group analogue) within databases and then assign your employees to these groups. There are no serverwide groups except of builtin server roles.
  • Adding logins and permissions
Answer this question