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