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

SQL Server Permission Manager is a suite of scripts that allows you to take "snapshots" of users and permissions across any or all of the databases on your SQL Server. These snapshots then allow you ...

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

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

We have covered things such as viewing the state of databases, backups and even creating SQL server logins. Today we are extending our look at user accounts by creating database users and then adding ...

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

I have worked with SQL Server ... harder to apply permissions to each individual Database User Account than to a Database role with a meaningful name. We also have access to Server roles where ...