September 8, 2005 at 1:01 am
I have a role named "DBRole"
I have given permissions to the role for Select,Insert,delete and Execute.
Now i add a user to this role named as "DBUser". to this role.
Thus all the permission of the 'DBRole' role is assigned to 'DBUser' user.
I want this DBRole to have Truncate Table permission,How can i do that.
Pavas
Dream The Dream
Explore the World
Experince The Exhilaration
September 8, 2005 at 1:56 am
You can't. TRUNCATE TABLE is not grantable. Members of sysadmin, db_owner and db_ddladmin have permission to use it, as well as the object owner.
September 8, 2005 at 4:38 am
Is there any method so that my program which uses Truncate table command under a
DBUser and DBRole can work
Pavas
Dream The Dream
Explore the World
Experince The Exhilaration
September 8, 2005 at 6:10 am
You could use an application role which is a member of for instance db_ddladmin. Let your program use this role when it needs to execute that statement.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply