Re: script object-level permissions

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

Date: Wed, 25 Jun 2003 23:55:43 -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.

>-----Original Message-----
>Are you sure the objects have permissions other than
default? I have never
>heard of this being an issue but if you can create a
repro script we can
>certainly take a look at it.
>
>--
>
>Andrew J. Kelly
>SQL Server MVP
>
>
>"cengiz" <cengizu@globis.com.tr> wrote in message
>news:08f901c33b0a$c5fa8ff0$a601280a@phx.gbl...
>> I'm sure that there isn't anything about permissions in
my
>> object script. The strange thing is that it works for
some
>> other databases in the same SQL Server instance.
>>
>>
>> >-----Original Message-----
>> >It has always worked fine for me. They may not be
>> physically next to the
>> >associated object in the script. Make sure you look
>> through the entire
>> >script.
>> >
>> >--
>> >
>> >Andrew J. Kelly
>> >SQL Server MVP
>> >
>> >
>> >"cengiz" <cengizu@globis.com.tr> wrote in message
>> >news:073101c33af2$e43b3d10$a601280a@phx.gbl...
>> >> I've a database on SQL Server 2000, when I want to
>> >> generate scripts of my objects, even if I
choose "script
>> >> object level permissions" , Sql Server does not
script
>> the
>> >> permissions that I've on my object.
>> >>
>> >> thanks in advance
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: assigning DB-user to server role
    ... You script seems to promise what we expected when we used the Enterprise ... > You should be able to grant object permissions to the roles only. ... > EXEC sp_addrole 'MyRole' ...
    (microsoft.public.sqlserver.security)
  • Re: cant get access to disk share when connecting from a remote s
    ... The systems are DUTs. ... for each of the drives within the system. ... Everything in the scripts work except the file permissions below the shares ... the shares on the DUTs manually, after they run my rename script, but I would ...
    (microsoft.public.windows.server.scripting)
  • Re: VBA Script to Read WMP 11 Database
    ... The script failed on the desktop when I downloaded WMP11, ... Just reviewing the bidding -- WMP 11 responds properly to commands in a VBS ... That's why the computer wouldn't let me manually change the permissions. ... Digital Media MVP: 2004-2007 ...
    (microsoft.public.windowsmedia)
  • Re: VBA Script to Read WMP 11 Database
    ... The script failed on the desktop when I downloaded WMP11, ... Just reviewing the bidding -- WMP 11 responds properly to commands in a VBS ... That's why the computer wouldn't let me manually change the permissions. ... The CREATOR OWNER is likely on windows to be one of the admin accounts ...
    (microsoft.public.windowsmedia)
  • Re: how to restrict users to search in their own Organizational Unit
    ... will be given the necessary permissions. ... Who would you DENY? ... decided a script can make it possible to accomplish, ... If I need to create a security group per OU and then add all users ...
    (microsoft.public.windows.server.active_directory)