Get list of users that have DBA grant
Hi, How I can generate a list of users that have DBA grant. Regards, Cesar Cruz Romero --------------------------------- Do You Yahoo!? Yahoo! Net: La mejor conexión a internet y 25MB extra a tu correo por $100 al mes.
SELECT username
FROM sysusers
WHERE usertype = "D";
Art S. Kagel
----- Original Message -----
From: Cesae Cruz <markaragnos17@yahoo.com.mx>
At: 4/ 4 13:53
>
> Hi,
>
> How I can generate a list of users that have DBA grant.
>
> Regards,
>
> Cesar Cruz Romero
>
>
>
>
> ---------------------------------
> Do You Yahoo!?
> Yahoo! Net: La mejor conexión a internet y 25MB extra a tu correo por $100 al
> mes.
The list of
users that have DBA grant inf on is:
database name_db
SELECT username FROM sysusers
WHERE usertype = "D";
bye
>From: "Cesae Cruz " <markaragnos17@yahoo.com.mx>
>To: ids@iiug.org
>Subject: Get list of users that have DBA grant [4666] Date: Mon, 4 Apr 2005
>13:50:20 -0400 (EDT)
>
>Hi,
>
>How I can generate a list of users that have DBA grant.
>
>Regards,
>
>Cesar Cruz Romero
>
>
>
>
>---------------------------------
>Do You Yahoo!?
>Yahoo! Net: La mejor conexión a internet y 25MB extra a tu correo por $100
>al mes.
>
>