How does DB2 view the current user mode and switch users?

How does DB2 view the current user mode and switch users?

1. connect to the database: db2 connect to study

2. query the current user mode: select current schema from sysibm. sysdummy1 or select current schema from sysibm. dual

3. Switch user mode: set current schema toms

4. Switch user: db2 connect to cpsdb user Administrator using 111111

5. grant permissions to other users: db2 grant dbadm on database to user odsuser

6. view the permissions of the current user: db2 get authorizations

Db2 database query user

Do you mean to query the database creation user or?

How does db2 switch the current tablespace?

This should not work.
When creating a table, specify a few more words. in xxxxx tablespace.