Re: script object-level permissions

From: cengiz uyar (cengizu_at_globis.com.tr)
Date: 06/26/03

  • Next message: cengiz: "Re: script object-level permissions" 
    Date: Wed, 25 Jun 2003 23:39:45 -0700

    generally when you change an object's permission, the sysprotects system
    table is affected, for example if you grant a object a row will be
    inserted in this table with your objects id. When I grant my object
    nothing changes in the sysprotects table, here is the statement and the
    output:

    sp_helprotect my_procedure

    Server: Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346
    There are no matching rows on which to report.

    When you script your objects with the "script object level permissions"
    option checked, sql server uses the

    exec sp_MSobjectprivs N'[dbo].[my_procedure]'

    procedure which does not return anything for my object.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!

  • Next message: cengiz: "Re: script object-level permissions"

    Relevant Pages

    • Re: Allowing Anonymous write access only.
      ... need at least READ permission for login. ... > been set up so that anonymous FTP users have write access only, this> may seem insecure and we do get a certain ammount of hackers or> taggers testing the system by dropping test files and folders onto the> server, but because anonymous users do not have read access they soon> find that they cannot download anything they upload and go elsewhere. ... This is where my problems have started,> I initialy replicated all the IIS setting and NTFS permission from my> NT box on my 2003 box but so far have been unable to achive the same> result, it appaers that I can only grant anonymous write access if I ...
      (microsoft.public.inetserver.iis.ftp)
    • Re: Yukon schemas
      ... ALTER to the schema. ... you have to grant create permission to perform the action ... data and to create and alter stored procedures and views that they owned. ...
      (microsoft.public.sqlserver.security)
    • Re: Local admin right
      ... use Group Policy Restricted Groups to enforce membership of local computer ... > account to local admin group to run some applications. ... > used this permission to grant someone else to access that box too. ...
      (microsoft.public.security)
    • Re: AppArmor Security Goal
      ... permission to /home/$user/.mozilla...... ... and grant each user access to only ... two shell scripts (one to start each browser profile) and set the AA policy ...
      (Linux-Kernel)
    • RE: Share Issues
      ... Where are the others shares located, in the old domain or new win2k3 ... How do you grant the permission to the "other shares", ... Microsoft Active Directory: Demo 3-Security Translation Wizard ...
      (microsoft.public.windows.server.migration)