in fixed database Roles (e.g., db_datareader ... type char(8), -- Type of Windows account. Valid values are user or group. privilege char(9) null, -- Access privilege for SQL Server. Valid values are ...

In SQL Server 2000, it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions. SQL Server 2005 makes assigning this ...

backups and even creating SQL server logins. Today we are extending our look at user accounts by creating database users and then adding them to specific roles for to provide the proper level of ...

In SQL Server, you can use the sp_help_revlogin stored procedure to generate the user login scripts. Another way to backup your database users is to use database tools that provide graphical ...

Newcomers to SQL Server always seem to confuse the ... We flippantly refer to Database User Accounts as “users” but this creates great confusion since Windows User Accounts are also called ...