Hello:
1.-UserID abc created
2.-DBRole abcRole created
3.-Several tables with schema abcschema and xyzschema exist
4.-Add userID abc to role abcRole
5.-on schema abcschema I add role abcRole
6.-on schema abcschema I grant select,insert,update,delete to role abcRole
Questions:
1.- login as abc
2.-I can not see any tables in the database, there are 45 tables with sbcschema, why?
3.-what I am missing?
4.-UserID abc does not have any grants.... since it is part of role abcRole
Please help.
Puzzle