deny permissions issues

Hi,

i'd like to deny permissions on system objects to the public role in a
database.

I have tried using the following commands without any success:

DENY SELECT ON SCHEMA::sys TO public

or

DENY SELECT ON sys.sysobjects TO public


Can someone tell me what is wrong in my commands?

Thx,

Chris

.

Relevant Pages

  • Re: Deny Create Database
    ... A sysadmin role member can do anything, so a DENY isn't going to work ... you won't need to use DENY. ... Even though the commands take fine and the syspermission table record ... off create database for a user in the sysadmin role or for a user who is not ...
    (microsoft.public.sqlserver.security)
  • Re: Custom 404 page
    ... placing the new commands under the FrontPage ... Ron ... >> deny from all ...
    (microsoft.public.frontpage.client)
  • Re: IPCop Cofinguration
    ... > No matter what order I put the ipchains ... > commands in, the whitelist address does ... You would need to DENY everything, and then add each of the ranges you ... I used ipchains to deny access to a variety of internet sites, ...
    (comp.security.firewalls)
  • Re: MAIL FROM: <>
    ... restart sendmail. ... How can I deny all MAIL FROM: commands from hosts which are not MX for a ...
    (Security-Basics)
  • Re: Users can import
    ... "Joan Wild" wrote: ... The ADH book has a function called adhSetDbCreate that will deny specified users/groups to create ... distributed workgroup file they will not be able to create a new database and link/import to the BE ... I do, however, also deny all permissions to the tables as Joan mentioned. ...
    (microsoft.public.access.security)