Re: [Info-Ingres] db_admin privilege

#1 (**permalink**) 04-20-2008, 09:38 PM

At 10:24 AM +0000 1/31/07, martin.bowes@ctsu.ox.ac.uk wrote:
>Hi Everyone
>
>I need to work out which users, groups or roles had been granted
>db_admin privilge and on which databases - or the entire installation.
>
>I know that iidbprivileges has the db_admin flag, and so a simple query
>using db_admin='Y' should suffice. But what is db_admin='U'?

U means Undefined, ie no permit was either specifically granted nor
revoked. It simply means that the particular iidbprivileges record
you're looking at has nothing to say about that particular privilege,
which remains unchanged from whatever it was before.

Karl

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode