Now this oughta be straightforward.  (Famous last words?)

Which system catalog(s) can I query to see which users have granted a specific role?

In catalog sysusers I see a group (sysusers where usertype = "G") named "managers". (Fake name, of course). What query can I run to see which users have been granted that role?  Or any role, for that matter?  My google search keep turning up les-than-helpful advice to use dbschema or just displaying the same page from the "Guide to SQL Syntax".

Thanks, all!

(WOW! Less than a page!  You're losing you touch, Jake! ;-)

Take a look at sysroleauth for the names of the roles.

Now this oughta be straightforward.  (Famous last words?)

Which system catalog(s) can I query to see which users have granted a specific role?

In catalog sysusers I see a group (sysusers where usertype = "G") named "managers". (Fake name, of course). What query can I run to see which users have been granted that role?  Or any role, for that matter?  My google search keep turning up les-than-helpful advice to use dbschema or just displaying the same page from the "Guide to SQL Syntax".

Thanks, all!

(WOW! Less than a page!  You're losing you touch, Jake! ;-)

That was it, Mike!  Thanks much.

Unfortunately for my efforts, it turns out that the solution to my user's issue will not involve roles.  They don't want to deal with "set role" and it's too big a solution for their issue anyway.

Take a look at sysroleauth for the names of the roles.

Now this oughta be straightforward.  (Famous last words?)

Which system catalog(s) can I query to see which users have granted a specific role?

In catalog sysusers I see a group (sysusers where usertype = "G") named "managers". (Fake name, of course). What query can I run to see which users have been granted that role?  Or any role, for that matter?  My google search keep turning up les-than-helpful advice to use dbschema or just displaying the same page from the "Guide to SQL Syntax".

Thanks, all!

(WOW! Less than a page!  You're losing you touch, Jake! ;-)

That was it, Mike!  Thanks much.

Unfortunately for my efforts, it turns out that the solution to my user's issue will not involve roles.  They don't want to deal with "set role" and it's too big a solution for their issue anyway.

Take a look at sysroleauth for the names of the roles.

Now this oughta be straightforward.  (Famous last words?)

Which system catalog(s) can I query to see which users have granted a specific role?

In catalog sysusers I see a group (sysusers where usertype = "G") named "managers". (Fake name, of course). What query can I run to see which users have been granted that role?  Or any role, for that matter?  My google search keep turning up les-than-helpful advice to use dbschema or just displaying the same page from the "Guide to SQL Syntax".

Thanks, all!

(WOW! Less than a page!  You're losing you touch, Jake! ;-)

Jacob,

Is it a case that the users would have to switch from role to role to do their work, and they don't want to do the SET ROLE TO xxxx?  Or is it a case that each user would only have one role, and they don't want to manually run the SET ROLE statement after logging in?

If it is the latter, did you let them know that each user can have a default role that is assigned each time they connect to the database?

That was it, Mike!  Thanks much.

Unfortunately for my efforts, it turns out that the solution to my user's issue will not involve roles.  They don't want to deal with "set role" and it's too big a solution for their issue anyway.

Take a look at sysroleauth for the names of the roles.

Now this oughta be straightforward.  (Famous last words?)

Which system catalog(s) can I query to see which users have granted a specific role?

In catalog sysusers I see a group (sysusers where usertype = "G") named "managers". (Fake name, of course). What query can I run to see which users have been granted that role?  Or any role, for that matter?  My google search keep turning up les-than-helpful advice to use dbschema or just displaying the same page from the "Guide to SQL Syntax".

Thanks, all!

(WOW! Less than a page!  You're losing you touch, Jake! ;-)

Hi Mark.

In my case, a user was requesting a set of identical privs to be granted to a large number of users.  I proposed the idea of a role to my user but wanted to keep control of the granting.  Hence my question to the group.  And it was simple - a catalog whose name I might have guessed after a while.

That aside, my user rejected the idea of a role, likely because several apps would have to be modified to add the "set role" command.  And most developers in a large wish to avoid the rigmarole of testing after the most minor (we think) of code changes.

Jacob,

Is it a case that the users would have to switch from role to role to do their work, and they don't want to do the SET ROLE TO xxxx?  Or is it a case that each user would only have one role, and they don't want to manually run the SET ROLE statement after logging in?

If it is the latter, did you let them know that each user can have a default role that is assigned each time they connect to the database?

That was it, Mike!  Thanks much.

Unfortunately for my efforts, it turns out that the solution to my user's issue will not involve roles.  They don't want to deal with "set role" and it's too big a solution for their issue anyway.

Take a look at sysroleauth for the names of the roles.

Now this oughta be straightforward.  (Famous last words?)

Which system catalog(s) can I query to see which users have granted a specific role?

In catalog sysusers I see a group (sysusers where usertype = "G") named "managers". (Fake name, of course). What query can I run to see which users have been granted that role?  Or any role, for that matter?  My google search keep turning up les-than-helpful advice to use dbschema or just displaying the same page from the "Guide to SQL Syntax".

Thanks, all!

(WOW! Less than a page!  You're losing you touch, Jake! ;-)

Hi Mark.

In my case, a user was requesting a set of identical privs to be granted to a large number of users.  I proposed the idea of a role to my user but wanted to keep control of the granting.  Hence my question to the group.  And it was simple - a catalog whose name I might have guessed after a while.

That aside, my user rejected the idea of a role, likely because several apps would have to be modified to add the "set role" command.  And most developers in a large wish to avoid the rigmarole of testing after the most minor (we think) of code changes.

Jacob,

Is it a case that the users would have to switch from role to role to do their work, and they don't want to do the SET ROLE TO xxxx?  Or is it a case that each user would only have one role, and they don't want to manually run the SET ROLE statement after logging in?

If it is the latter, did you let them know that each user can have a default role that is assigned each time they connect to the database?

That was it, Mike!  Thanks much.

Unfortunately for my efforts, it turns out that the solution to my user's issue will not involve roles.  They don't want to deal with "set role" and it's too big a solution for their issue anyway.

Take a look at sysroleauth for the names of the roles.

Now this oughta be straightforward.  (Famous last words?)

Which system catalog(s) can I query to see which users have granted a specific role?

In catalog sysusers I see a group (sysusers where usertype = "G") named "managers". (Fake name, of course). What query can I run to see which users have been granted that role?  Or any role, for that matter?  My google search keep turning up les-than-helpful advice to use dbschema or just displaying the same page from the "Guide to SQL Syntax".

Thanks, all!

(WOW! Less than a page!  You're losing you touch, Jake! ;-)

That was it, Mike!  Thanks much.

Unfortunately for my efforts, it turns out that the solution to my user's issue will not involve roles.  They don't want to deal with "set role" and it's too big a solution for their issue anyway.

Take a look at sysroleauth for the names of the roles.

Now this oughta be straightforward.  (Famous last words?)

Which system catalog(s) can I query to see which users have granted a specific role?

In catalog sysusers I see a group (sysusers where usertype = "G") named "managers". (Fake name, of course). What query can I run to see which users have been granted that role?  Or any role, for that matter?  My google search keep turning up les-than-helpful advice to use dbschema or just displaying the same page from the "Guide to SQL Syntax".

Thanks, all!

(WOW! Less than a page!  You're losing you touch, Jake! ;-)

Now this oughta be straightforward.  (Famous last words?)

Which system catalog(s) can I query to see which users have granted a specific role?

In catalog sysusers I see a group (sysusers where usertype = "G") named "managers". (Fake name, of course). What query can I run to see which users have been granted that role?  Or any role, for that matter?  My google search keep turning up les-than-helpful advice to use dbschema or just displaying the same page from the "Guide to SQL Syntax".

Thanks, all!

(WOW! Less than a page!  You're losing you touch, Jake! ;-)