Users & Schemas
1) What is difference between users and schemas in DB2.
2) In DB2 instance:
a) Under user created database, I have under schemas:
DB2ADMIN, NULLID, SYSCAT, SYSFUN, SYSIBM, SYSSTAT. Under users & group objects, we have DB Users containing DB2ADMIN & USERID and DB Groups containing PUBLIC.
b) Under DWCTRLDB, I have under schemas:
FLG, IWH, NULLID, SYSCAT, SYSFUN, SYSIBM, SYSSTAT. Under users & group objects, we have DB Users containing DB2ADMIN & PUBLISH and DB Groups containing PUBLIC.
4) In DB2CTLSV instance:
a) Under SATCTLDB, I have under schemas:
NULLID, SATADMIN, SYSCAT, SYSFUN, SYSIBM, SYSSTAT. Under
users & group objects, we have DB Users containing DB2ADMIN and DB Groups containing PUBLIC.
5) What each of these schemas, db users and db groups signify and where can I find password to connect to them from remote client.
6) For all schemas, authorization is SYSIBM except SATADMIN which has DB2ADMIN as authorization. What do these 2 authorizations signify.
7) Schemas are for authentication to DB. There are no authorizations for schemas but they exist for other database objetcs, am I right?
8) DB Users means what. How is it different from schemas. I can see a set of 7 authorizarion/privileges for DB Users. There is a schema ITSO for user database DB User db2admin. What is this schema under an user.
9) Same is the case with User groups. We see all this in change user or change group window. Are there no roles in DB2 like oracle. Are DB Users & Groups like roles.
10) How do we create a group.
2) In DB2 instance:
a) Under user created database, I have under schemas:
DB2ADMIN, NULLID, SYSCAT, SYSFUN, SYSIBM, SYSSTAT. Under users & group objects, we have DB Users containing DB2ADMIN & USERID and DB Groups containing PUBLIC.
b) Under DWCTRLDB, I have under schemas:
FLG, IWH, NULLID, SYSCAT, SYSFUN, SYSIBM, SYSSTAT. Under users & group objects, we have DB Users containing DB2ADMIN & PUBLISH and DB Groups containing PUBLIC.
4) In DB2CTLSV instance:
a) Under SATCTLDB, I have under schemas:
NULLID, SATADMIN, SYSCAT, SYSFUN, SYSIBM, SYSSTAT. Under
users & group objects, we have DB Users containing DB2ADMIN and DB Groups containing PUBLIC.
5) What each of these schemas, db users and db groups signify and where can I find password to connect to them from remote client.
6) For all schemas, authorization is SYSIBM except SATADMIN which has DB2ADMIN as authorization. What do these 2 authorizations signify.
7) Schemas are for authentication to DB. There are no authorizations for schemas but they exist for other database objetcs, am I right?
8) DB Users means what. How is it different from schemas. I can see a set of 7 authorizarion/privileges for DB Users. There is a schema ITSO for user database DB User db2admin. What is this schema under an user.
9) Same is the case with User groups. We see all this in change user or change group window. Are there no roles in DB2 like oracle. Are DB Users & Groups like roles.
10) How do we create a group.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER