Re: How to deny DBCC SQLPERF(logspace)

From: Michael Shao [MSFT] (v-yshao_at_online.microsoft.com)
Date: 11/03/03 

Date: Mon, 03 Nov 2003 13:56:12 GMT

Hi Yoshihiro,

Thanks for your feedback. sp_srvrolepermission returns the permissions
applied to a fixed server role. sp_dbfixedrolepermission displays the
permissions for each fixed database role. Because this query based on these
two stored procedure, it is normal that there is not public role.

Also, I would like to say that this query based on the two stored procedure
and these stored procedure only returns the permissions applied to fixed
server role or fixed database role. Therefore the permissions of each DBCC
command resulted from the query are not completely.

I hope the explanation is clear. Please let us know if you need further
assistance on this issue.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Relevant Pages

  • Re: xp_startmail: wont run as non sa user
    ... Execute permissions for xp_startmail default to members of the db_owner ... fixed database role in the master database and members of the sysadmin fixed ... server role, but can be granted to other users. ...
    (microsoft.public.sqlserver.programming)
  • Re: restricted user level security
    ... All of my queries and macros are built off the Supervisor name, ... query, the query includes all of the fields and the CurrentUsercriteria. ... I changed the Run Permissions to Owner. ... you can set up user level security. ...
    (microsoft.public.access.security)
  • Re: Object permissions
    ... Who is the owner of the query? ... permissions does the owner have on the underlying tables? ... does the user have on the query; ... to 'owners' in the sql statement each time the code runs, ...
    (microsoft.public.access.security)
  • Re: Advance Security Issue Part II
    ... >> Okay, I've got the dual-mdw thing all straight, now I have a permissions ... >> created a Snapshot query to read that table. ... > because the effects of the WITH OWNER ACCESS ... > does not exist in the current workgroup file. ...
    (microsoft.public.access.security)
  • Re: rwop
    ... You can create a RWOP query for each of your ... base queries need to be RWOP; the queries based on these do not. ... esecially concerning how I have set the permissions for users. ... with the permissions of the owner. ...
    (microsoft.public.access.security)