Re: How to deny DBCC SQLPERF(logspace)

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

  • Next message: Rex: "how to protect database" 
    Date: Fri, 31 Oct 2003 09:55:36 GMT

    Hi Yoshihiro,

    Thanks for your feedback. The Transact-SQL programming language provides
    DBCC statements that act as Database Console Commands for Microsoft? SQL
    Server? 2000. These statements check the physical and logical consistency
    of a database.

    I know that if we can find the place where the permissions of each DBCC
    command stored, we can update the table directly to change the permissions.
    However, as I understand, that they are different from the objects in the
    database. I am unable to find the place stored the permissions of each DBCC
    command so that it is not easily to list the permissions of each DBCC
    command.

    If you just want to view the permission of the DBCC command, you can search
    the DBCC command in the SQL Server Books Online and find the permissions
    under the "Permissions" subtopic for this DBCC command.

    Please feel free to post in the group if this solves your problem or if you
    would like further assistance.

    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.

  • Next message: Rex: "how to protect database"

    Relevant Pages

    • Re: DBCC error 913
      ... Then I run the command sp_dboption dbname,'Single user',true also. ... this command runs inside a cursor and DBCC checkdb commands starts after that. ... >> This is simple DBCC script I am running on the server every sunday. ... >> database is online and in live. ...
      (microsoft.public.sqlserver.server)
    • Re: Avoiding the use of CACHE in SQL2000
      ... I'll read each command. ... > DBCC FREEPROCCACHE clears the procedure cache and causes ad hoc queries to ... > if you want to clear the data cache you will need to use DBCC ... > specific database on a SQL Server, ...
      (microsoft.public.sqlserver.programming)
    • dbcc shrinkdatabase
      ... I'm trying to run the "dbcc shrinkdatabase" command on a specific database. ... I don't see any error messages but its obvious that the command never ran. ...
      (comp.databases.ms-sqlserver)
    • Re: who can execute DBCC commands ?
      ... ::fn_get_sqlas per Kalen's article in SQL Mag a year ago: ... to GRANT different permissions to SELECT from it. ... >> Its dbcc inputbuffer.. ... >>> It depends on which DBCC command you are talking about. ...
      (microsoft.public.sqlserver.server)
    • Re: who can execute DBCC commands ?
      ... ::fn_get_sqlas per Kalen's article in SQL Mag a year ago: ... to GRANT different permissions to SELECT from it. ... >> Its dbcc inputbuffer.. ... >>> It depends on which DBCC command you are talking about. ...
      (microsoft.public.sqlserver.server)