Any unsurpassed method to start-off this procedure an appropriate
I’m used to a setup which welcomes anyone who wishes a sort of an executive entry to a domain only to get imputed to the domain admin’s group. I apologize for such faulty actions, and am now separating all of our “admins” into their own groups. Specifically, I have users who require permission to assign [...]

Answer Question   |  April 19, 2013  5:31 AM
SQL Server, SQL Server permissions

SQL Server 2005 permissions required by public
Our security madates that ALL object permissions be removed from”public”. After doing that, no one can see their tables or do anything. What are the absolutly NEEDED permissions required by public (Execute, Select, etc.)?

Answer Question   |  February 15, 2011  6:46 PM
SQL Security, SQL Server 2005, SQL Server 2005 security, SQL Server permissions

Kerberos unconstrained delegation for MS SQL svc account
Can an MS SQL service account run non-SQL services if “trust this user for delegation to any service (Kerberos only) has been enabled?

Answer Question   |  August 26, 2010  2:11 AM
Kerberos, MSSQL, SQL Server permissions, SQL Server security

Permission to Export SQL Server 2005
On SQL Server 2005, what is the minimum permission needed to allow a user to export tables from one database server to another server? Permission on SOURCE=? Permission on DESTINATION=?

Answer Question   |  April 9, 2010  7:55 PM
SQL Server 2005, SQL Server 2005 administration, SQL Server permissions

Access Rights in SQL Server 2005
Hi,  I’m using sql server 2005 and in my application i have 2 DB say A and B , and 2 servers SR1,SR2 and DB A,B and present on both (SR1,SR2).now i want to give access to users entering my DB not to view any of the entries made in the DB, not even the [...]

Answer Question   |  January 7, 2010  6:29 AM
SQL Server 2005, SQL Server permissions, SQL Server User Accounts, Windows Vista

Migrate User & Permissions SQL 2000 to SQL XXXX
Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.

Answer Question   |  June 25, 2009  4:26 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration, SQL Server permissions, SQL Server User Accounts, SQL Server user permissions, Upgrade from SQL Server 2000 to SQL Server 2005

Acces rights for all user of an SQL SERVER 2005
Hi all, have you an idea how can i export the list of users and there acces rights of an SQL SERVER 2005; THANK YOU

Answer Question   |  April 2, 2009  3:43 PM
SQL Server 2005, SQL Server permissions, SQL Server user permissions

Deny domain administrators to select from sql server tables ( SQL server 2005)
I have added the “domain admin” group to the Sql Server, and set permission as “Deny” to connect to the database engine. All employees of this group can still select from any table. The sql server “public” role does not have any permissions on any database table. The “domain admin ” group has local admin [...]

Answer Question   |  March 2, 2009  8:28 PM
SQL Server, SQL Server permissions, SQL Server security, SQL Server tables

Configuring a password message prompt on SQL Server 2000
On SQL Server 2000, how can I make it so that the server will prompt me for a password when I am click on my database through Enterprise Manager?

Answer Question   |  November 21, 2008  7:09 PM
Enterprise Manager, SQL Server 2000, SQL Server permissions

Giving login and database permissions to a group in SQL Server 2005
I am running SQL Server 2005 Workgroup Edition on Windows Server 2003 Standard Edition. I have created a global security group called ACSSales and I would like to give login and database permissions to this particular group, rather than individual user permissions. How do I do this?

Answer Question   |  August 4, 2008  2:20 PM
SQL Server 2005, SQL Server permissions, Windows Server 2003

Password policies for SQL Server 2005 (Yukon)
What are the password policies within SQL Server 2005 (Yukon)?

Answer Question   |  July 17, 2008  4:44 PM
SQL Server 2005, SQL Server permissions, Yukon

Excluding Data Usin NOT IN
I’m trying to export data from a sql table into sql reporter. The information I’m trying to retrieve is information regarding permissions (this is audit stuff). The problem is, there are spaces (and always a different amount of spaces) between the user and the permissions; for example: Type Account Permissions —– —————————- ————– Allow CREATOR [...]

Answer Question   |  July 8, 2008  1:10 PM
SQL Server permissions, SQL Server reporting, SQL statements