Re: script object-level permissions

From: Andrew J. Kelly (ajkellynospam_at_attbi.com)
Date: 06/25/03 

Date: Wed, 25 Jun 2003 17:54:28 -0400

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: DTS package to copy database
    ... Why not BACKUP and RESTORE and then apply scripts to change any owners, ... Create a SQL Script to remove the constraints ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >>> The DB permissions are set for local users on each machine (including ...
    (microsoft.public.sqlserver.dts)
  • Re: How do you create a databse?
    ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's ... > I think that it may be time to use a script to create databases. ...
    (microsoft.public.sqlserver.server)
  • Re: DTS package to copy database
    ... Create a script that will drop DRI on the destination ... Create a DTS package to pump all data from Source --> Destination ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >>> The DB permissions are set for local users on each machine (including ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL state (error) is 37000
    ... What is being changed is new footage data. ... SQL Server would always be able to finish the job before the next job needed ... >>It is a way to transport data between databases. ... >>the script below? ...
    (microsoft.public.sqlserver.connect)
  • 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)