Re: script object-level permissions

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

Date: Wed, 25 Jun 2003 04:13:15 -0700

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: Configuring SQL 2000 for use with ESRI ArcSDE
    ... You can assign SQL Server users to database roles using sp_addrolemember: ... Permissions are entirely application specific. ... vendor for clarification of security requirements. ... I have Two databases 3 Roles ...
    (microsoft.public.sqlserver.server)
  • Re: Permission to restore databases and access them without being
    ... dbcreator to the login so that you can restore the databases. ... " in SQL Server 2005 Books Online: ... assign your wanted permissions such as db_reader/db_writer ...
    (microsoft.public.sqlserver.security)
  • Re: Hiding database
    ... Jasper Smith (SQL Server MVP) ... >>>Can someone explan how to hide databases in enterprise manager. ... >> permissions are granted to these users. ... > have access rights to one of them. ...
    (microsoft.public.sqlserver.tools)
  • Re: Security Script
    ... You when you restore a database, or attach it, SQL Server maintains the ... logins but removes all permissions to databases and their objects. ...
    (microsoft.public.sqlserver.security)
  • Implementing Data Warehouse
    ... We have one SQL Server 2000 with several different databases from 3rd party ... procedures, etc) from OUR custom database called LEITER, on the same SQL ... permissions are guaranteed to work. ...
    (microsoft.public.sqlserver.datawarehouse)