Re: Security in EM

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 01/03/04

  • Next message: Dejan Sarka: "Re: DDL Permissions - CREATE PROCEDURE, but no CREATE TABLE" 
    Date: Fri, 2 Jan 2004 22:33:07 -0800

    No, you cannot hide the metadata. Any user in a database can execute sp_help
    (which is basically what is running behind the scenes when you click on an
    object in EM). 

    --
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Pauline" <anonymous@discussions.microsoft.com> wrote in message
news:043a01c3d1b3$c7196fb0$a501280a@phx.gbl...
> After revoking all privileges on an object A of an user A,
> I can still see the object in the Enterpise Manager and
> double click for the table structure.
>
> Can the object A be hidder from user A?
>
> Thanks.
  • Next message: Dejan Sarka: "Re: DDL Permissions - CREATE PROCEDURE, but no CREATE TABLE"

    Relevant Pages

    • Re: question?
      ... > question about the fedora project. ... If something like that (meaning the built in database ... of getting transactions to span filesystems. ... This is the metadata problem, or rather, series of problems. ...
      (Fedora)
    • Re: Question regarding to store file system metadata in database
      ... database, because the time used to read filelist and do statare ... considering the possibility of storing metadata in database. ... kernel boundary, I am expecting a moderate performance impact. ... the kernel to a userspace database process, ...
      (Linux-Kernel)
    • Re: Cross-database execution permissions with certificates and sch
      ... activated user cannot access objects in other schemas in this database. ... injection is defended against, however, the threat exists anywhere EXECUTE ... CREATE USER dispatcher ... the certificate is a trusted authenticator because you granted AUTHENTICATE ...
      (microsoft.public.sqlserver.security)
    • Re: Execute Persmission denied on object sp_OACreate
      ... SQL Server doesn't check permissions on indirectly referenced objects as ... You can prevent ad-hoc execution of powerful master database procs while ... >I have a user who has execute permissions on a store procedure in a>database> which in turns executes 4 stored procedures in the master database. ...
      (microsoft.public.sqlserver.security)
    • Re: SQLCE performance from .NET CF v2.0
      ... Please remember when bulk inserting is being executed against SQL CE, ... > local database functionality. ... > database technology and I am considering switching to SQLCE at the same ... > execute the prepared statement again. ...
      (microsoft.public.dotnet.framework.compactframework)