A couple of quick questions about SQL Server 6.5

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Russell (Russell_at_discussions.microsoft.com)
Date: 09/18/04 

Date: Sat, 18 Sep 2004 09:23:03 -0700

I have a couple of quick questions to do with SQL 6.5.

1. Is there a stored proc that I can use in conjunction with
sp_foreachtable to step though all the user tables and list the permissions
that the public role has.

2. When I use the generate SQL Script , to have it script up all the
logins,users and permissions. I then look at the resulting script and it seem
to set all the passwords to (Null). Is there a way to have the passwords
intact?

Relevant Pages

  • Re: Permissions replication
    ... for a permissions script connect to your database using EM. ... the publication database, and select all tasks, generate SQL Script. ... Looking for a book on SQL Server replication? ... >>Looking for a book on SQL Server replication? ...
    (microsoft.public.sqlserver.replication)
  • Re: permissions gone missing in sysprotects
    ... Hi Jack, if you have the SQL 7,0 instance still available, once you have ... you could script the permissions from the SQL 7.0 instance using the ... ‘Create’ and ‘Drop’ options from the Formatting Tab and then select ... ‘Script object level permissions’ from the Options Tab, ...
    (microsoft.public.sqlserver.security)
  • Re: Script Objects (Table. SP etc.) without Permissions (Grants)
    ... the version of SQL Server you are using. ... this only excludes objects with explicit permissions. ... I want to script all objects that have no permissions granted on ... Bob Barrows ...
    (microsoft.public.sqlserver.programming)
  • Re: Script Objects (Table. SP etc.) without Permissions (Grants)
    ... the version of SQL Server you are using. ... this only excludes objects with explicit permissions. ... I want to script all objects that have no permissions granted on ... Bob Barrows ...
    (microsoft.public.sqlserver.programming)
  • Re: GPO Preferences experiences?
    ... The "error" is inside the MS SQL Driver. ... So the driver can not script passwords, ...
    (microsoft.public.windows.group_policy)