RE: DBCC dllname (FREE)

Hi Dana,
My understanding of your issue is that:
You found that DBCC dllname(FREE) could not be executed with db_owner. You
could run it with sysadmin.
If I have misunderstood, please let me know.

I looked through our internal database and found that this was a
documentation issue ( 223167 ) of BOL.
BOL should read:
DBCC dllname (FREE) permissions default to members of the sysadmin fixed
server role, and are not transferable.

Please assign the login account with sysadmin permission to run the
statement.

If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================



.

Relevant Pages

  • Re: Performance and permissions
    ... after adding the user in question to EVERY group except SysAdmin ... (and the deny groups) ... Here are the permissions I was not able to give this ... dbcc change ‘on’ rules ...
    (microsoft.public.sqlserver.security)
  • Re: who can execute DBCC commands ?
    ... Its dbcc inputbuffer.. ... > commands that you need to sysadmin in order to run them (for example ... > DBCC traceon) and other commands that you can be dbo (for example DBCC ...
    (microsoft.public.sqlserver.server)