![]() I'm not sure is it a bug or just the way 'dbschema' works. It causes some troubles when you're about to clear the permissions on a particular database out as this 'U' right gives a user actually 'connect' permission (according to ServerStudio and that I can connect). This type of a user is created when you're granting a user with default role: GRANT DEFAULT ROLE 'IT' TO 'username' # echo "select * from sysusers where username = 'livenetapps1' " | dbaccess sei_copy_focus # dbschema -p livenetapps1 -d sei_copy_focus -ss | grep -v revokeĭBSCHEMA Schema Utility INFORMIX-SQL Version 11.50.FC6W4WE # dbschema -p all -d sei_copy_focus -ss | grep livenetapps1 IBM Informix Dynamic Server Version 11.50.FC6W4WE Software Serial Number AAA#B000000 Nothing strange (apart from not many words about this in the documentation) would be in this if that the 'dbschema' doesn't show such 'U' users at all. It's a 'U' (next to 'D', 'R', 'C') type of a user. There's also one more, not well documented, user type apart from these 3 which caused a bit of trouble for me recently. Using dbschema -p -d you get permissions that the user has on a specifig database's objects - including obviously a type of database-level right (one of dba/resource/connect).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |