Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS

General
Enthusiast

Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS

HI All,

Could you please tell us, what is the basic difference between DBC.ROLEINFO and DBC.ALLROLERIGHTS?

Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS.

Thanks,

Arka

2 REPLIES
Enthusiast

Re: Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS

DBC.RoleInfo view provides information of all roles defined (It is derived from DBC.Roles table)

DBC.AllRoleRights view provides information about the rights granted to each role

You can find out how these views are defined internally using:

SHOW SEL * FROM DBC.ROLEINFO ;
SHOW SEL * FROM DBC.ALLROLERIGHTS;
Enthusiast

Re: Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS

Thanks Sachin,

it's like untill the role is not assigned/granted to any databases, we cannot see the same in 'ALLROLERIGHTS'.