GK - Persmission on each database ( objects )

From: GKramer (anonymous_at_discussions.microsoft.com)
Date: 03/30/04 

Date: Mon, 29 Mar 2004 21:16:07 -0800

Hi,

Second attempt to post this same message ( yesterdays post is not to be foud in this forum ??? ).

I like to retrieve ALL permissions on all abjects for each user ( each role, each login ) in ALL of the databases within one server environment. I tried the standard "sp_" procs but they are to limited for this.
I have to deal with approx 250 databases on approx 60 servers so I like to have something which I can use on server level and not on table level ( like the standard procs ).
As an Oracle DBA I'm not that familiar with scripting on SQL server 2000 so l need your help on this one.

who can help me out?

Thanks in advance,
Regards, GKramer
The netherlands.
   

Relevant Pages

  • Re: How to Create Local Temporary Table
    ... SQL Server any time I can. ... I am an Oracle DBA an proud of it. ... When most think of scripting in Windows, they think of DOS command line ... I do use windows with Cygwin and I like the experience. ...
    (comp.databases.oracle.server)
  • Re: How to Create Local Temporary Table
    ... I have worked with both Oracle and SQL Server for some time and have grown to appreciate how much more mature Oracle is than SQL Server. ... When most think of scripting in Windows, they think of DOS command line scripting. ...
    (comp.databases.oracle.server)
  • Re: Sql Management Studio - Script Db creates objects out of ourder
    ... Scripting depends on the dependency information in the database. ... flexible nature of SQL Server, ... and the a stored procedure kalle_sp that refers ... to nissetbl, SQL Server with store information about this. ...
    (microsoft.public.sqlserver.tools)
  • Re: Scripting Performance after SP2 applied?
    ... I agree that there is a lot of time spent setting up the scripting in the ... As far as memory configuration, I have always set my max server memory set ... now with forced parameterization, ... I then restarted SQL Server, and set the database to forced ...
    (microsoft.public.sqlserver.tools)
  • Re: SMSS SP2 Script Database objects error
    ... Determining objects in database 'NameHost' that will be scripted. ... query using ANSI outer join operators (LEFT OUTER JOIN, ... In the future versions of SQL Server, ... scripting, I find it difficult to believe that it would be that bad. ...
    (microsoft.public.sqlserver.tools)