Re: script object-level permissions

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

Date: Wed, 25 Jun 2003 06:57:06 -0400

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: Any Help Please
    ... Then check the "Script all objects" checkbox. ... This way you get a script of all object-level permissions which you can run against the SQL Server 2005 database. ... While the object level permissions are at the database level and should be restored with the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot Open SQL Server Table in Access.ADP File.
    ... Other possiblities would be that you didn't refresh the database window ... I have an SQL Server 2005 database which functions properly with my ... the Generate Script Wizard to recreate the SQL Server Database. ... Then, If I attempt to open another table, it opens. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Connecting to SQL Server Express 2005
    ... Microsoft KB (which was referenced in the very useful DataBase Journal ... generated script against my test database. ... The SQL server produced the following list of errors: ... Line 2: Incorrect syntax near 'GO'. ...
    (microsoft.public.sqlserver.connect)
  • RE: Project Server 2003
    ... when I got to the run script step, I ran the script from the copied database ... I was also wondering about the create database ... For example, type Project Server, and then click OK. ... In the left pane of SQL Server Management Studio, expand Databases, ...
    (microsoft.public.windows.server.sbs)
  • Re: Database Access
    ... Do you create the group in SQL Server on the NT Domain? ... >> from a client script to ... > the database server would not be possible from client machines. ... You will want the sqloledb connection string. ...
    (microsoft.public.scripting.jscript)