August 14, 2003 at 7:40 am
I've created logins that are used in certain DTS packages. In the DTS package, certain tables need to be truncated. Does giving the login ddladmin rights on a database allow the user to truncate all tables? How can I change it so the login can only truncate certain tables.
Thanks!
August 14, 2003 at 9:15 am
From BOL.
"Permissions
TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not transferable."
August 14, 2003 at 2:25 pm
So if I give a login db_ddladmin database roles, then can it truncate all tables in the database? I only want a certain login to be able to truncate only certain tables.
thanks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy