Restrict user to delete database object in SQL SERVER 2005
-
Dear All, I want create new user in SQL server 2005, and allow this user to run any SQL script ( most of this script use to select data using store procedure, create temp table , delete temp table...). I want to protect this user, not allow him to delete any object such as database, table , view, function... Can anyone help me please, I'm really stuck with searching... Thanks.
-
Dear All, I want create new user in SQL server 2005, and allow this user to run any SQL script ( most of this script use to select data using store procedure, create temp table , delete temp table...). I want to protect this user, not allow him to delete any object such as database, table , view, function... Can anyone help me please, I'm really stuck with searching... Thanks.
LTM_it_kh wrote:
I want to protect this user, not allow him to delete any object such as database, table , view, function...
Can anyone help me please, I'm really stuck with searching...Permissions[^] ..it's not "protecting" the user, but "limiting" the user.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
Dear All, I want create new user in SQL server 2005, and allow this user to run any SQL script ( most of this script use to select data using store procedure, create temp table , delete temp table...). I want to protect this user, not allow him to delete any object such as database, table , view, function... Can anyone help me please, I'm really stuck with searching... Thanks.
Hi You will give the access rights to that user through TSQL or SQL Server Management Studio... Check the following links Script to determine permissions in SQL Server 2005[^] Configuring user permissions for Microsoft SQL Server[^] Assigning permissions and roles in SQL Server 2005/2008 databases[^]
-
Hi You will give the access rights to that user through TSQL or SQL Server Management Studio... Check the following links Script to determine permissions in SQL Server 2005[^] Configuring user permissions for Microsoft SQL Server[^] Assigning permissions and roles in SQL Server 2005/2008 databases[^]