RE: Script logins, passwords & database access

From: Alvin Zhao[MSFT] (alvinzh@online.microsoft.com)
Date: 01/17/03 

From: alvinzh@online.microsoft.com (Alvin Zhao[MSFT])
Date: Fri, 17 Jan 2003 07:15:46 GMT

Hi Russell,

Since you have a script that scripts out logins from databases except
default databases, you can look through the script and find why the default
databases are omitted. Possible the script uses a WHERE predicate to rule
out the system databases when finding all the databases in the SQL Server.
Just find it and remove it. You can find the database grant information in
the INFORMATION_SCHEMA.TABLE_PRIVILEGES view and
INFORMATION_SCHEMA.COLUMN_PRIVILEGES view.

In addition, you can manually generate the scripts for object in database
in Enterprise Manager. In SQL 2000 Enterprise Manager, right-click on the
database name (not on some object), select All Tasks - Generate SQL
Scripts, verify that on the General tab you can select the right objects
you desired, on Options tab select users, logins and permissions.

Sincerely,

Alvin Zhao
Microsoft Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: object level permissions being lost when migrating
    ... I am talking about SQL Logins, ... can go to the object and see that user X has permissions XYZ on that object, ... I then restored the databases and re-synched the users via the ...
    (microsoft.public.sqlserver.security)
  • Re: Recovery Model Question.
    ... Take the result of the script, paste in into a query window and execute it. ... I run this sql script through Query Analyzer: ... to any databases!I check the recovery model and remains unfortunately full in all databases.. ...
    (microsoft.public.sqlserver.tools)
  • Script log-shipping configuration and steps for disaster recovery
    ... I am making the disaster recovery plan for the sql 2005 databases at ... of script this so I just run the script for the rest of the databases ... instead of going through the wizard 40 times. ...
    (microsoft.public.sqlserver.replication)
  • Re: Need guidance
    ... Close all databases that are being shared by FM7 sever. ... Open FM7 pro 7 to execute a script that will import data from another file ... Open all databases in FM7 server to be shared. ...
    (comp.databases.filemaker)
  • Reverting to previous found set from script
    ... Hi guys and girls ... I'm new to FileMaker but not to databases in general. ... So the principles behind relational database operation aren't a problem for me to understand; what I'm having difficulty with is making FileMaker's script steps duplicate what I can do manually. ... If I am in a found set of records, or indeed am looking at all of them, when I click into find mode and enter something which I know can't be found, FileMaker presents an error message and allows me to continue or cancel. ...
    (comp.databases.filemaker)