Re: GK - Persmission on each database ( objects )

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 11:04:34 +0530

Hi,

Have a look into syspermissions system table, which stores all the
previleges granted using GRANT statement.

Thanks
Hari
MCDBA

"GKramer" <anonymous@discussions.microsoft.com> wrote in message
news:D6C88E0C-8C67-4DAE-AB3E-9CBCD061AA28@microsoft.com...
> 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: GK - Persmission on each database ( objects )
    ... previleges granted using GRANT statement. ... each login) in ALL of the databases within one server environment. ... have something which I can use on server level and not on table level (like ... the standard procs). ...
    (microsoft.public.sqlserver.security)
  • Re: DNS issues for machines with DHCP reservations.
    ... The DHCP/DNS Server is a fully patched Win 2K SP4 box. ... DHCP servers on the network. ... weird, because the client gets an IP and all of the correct settings, but the ... > Options set as a Scope or Server Level? ...
    (microsoft.public.win2000.dns)
  • Stopping incoming e-mails with the Novarg (MyDoom) virus
    ... Our e-mail server is not very sophisticated in order to ... be able to apply the filters at the server level. ... incoming messages until the person who has the infected ...
    (microsoft.public.security.virus)
  • Re: OWA2007 direct file server access lack of fine grained control?
    ... The granularity allowed is at the server level, using the -RemoteDocumentsAllowedServers and -RemoteDocumentsBlockedServers switches with the set-OwaVirtualDirectory command: ... it turns out that there is very little control in terms of restricting ... We have all our file shares(staff home dirs, student home dirs, corporate ...
    (microsoft.public.exchange.admin)
  • Re: Exchange 2003-SP2 OWA perod at end of subject line - No urlscan
    ... Found the problem, it was an ISAPI filter at the server level in IIS, removed it and added it again at the website level and the problem was fixed. ...
    (microsoft.public.exchange.clients)