General information
Forum:
Microsoft SQL Server
Del,
Please find below text from MSDN library about this command:
"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."
Cheers,
Zoran
>Hi all:
>
>I'm attempting to issue the TRUNCATE TABLE command from VFP via SQL Pass Thru. When I issue the command, it does not success and I get an error that the user does not have permission to perform this operation on the table in question. In SQL Enterprise Manager, I do not see where I can explicitly grant this permission to a particular user or role.
>
>Will I have to use an administrator level user/role for this? If not, what am I missing?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only