— 创建基本用户
CREATE USER app_user IDENTIFIED BY password
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 100M ON users;– 授予基本权限
GRANT CONNECT, RESOURCE TO app_user;– 查看用户信息
SELECT username, default_tablespace, temporary_tablespace
FROM dba_users
WHERE username = ‘FGAPP_USER’;

— 创建具有特定权限的用户
CREATE USER read_only_user IDENTIFIED BY password
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;– 授予只读权限
GRANT CREATE SESSION TO read_only_user;GRANT SELECT ANY TABLE TO read_only_user;– 查看用户权限
SELECT grantee, privilege
FROM dba_sys_privs
WHERE grantee = ‘READ_ONLY_USER’;

— 修改用户密码
ALTER USER app_user IDENTIFIED BY new_password;– 修改用户默认表空间
ALTER USER app_user DEFAULT TABLESPACE new_tablespace;– 修改用户临时表空间
ALTER USER app_user TEMPORARY TABLESPACE new_temp_tablespace;– 锁定用户
ALTER USER app_user ACCOUNT LOCK;– 解锁用户
ALTER USER app_user ACCOUNT UNLOCK;– 删除用户
DROP USER app_user CASCADE;

— 1. 创建应用用户
SQL> CREATE USER myapp IDENTIFIED BY MyApp123
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 500M ON users;User created.

— 2. 授予应用所需权限
SQL> GRANT CONNECT, RESOURCE TO myapp;Grant succeeded.

— 3. 授予特定对象权限
SQL> GRANT SELECT, INSERT, UPDATE, DELETE ON hr.employees TO myapp;Grant succeeded.

— 4. 验证用户创建
SQL> SELECT username, default_tablespace, temporary_tablespace
FROM dba_users
WHERE username = ‘MYAPP’;USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
———- —————– ——————-
MYAPP USERS TEMP

— 1. 创建只读用户
SQL> CREATE USER report_user IDENTIFIED BY Report123
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;User created.

— 2. 授予只读权限
SQL> GRANT CREATE SESSION TO report_user;Grant succeeded.

— 3. 授予对特定表的只读权限
SQL> GRANT SELECT ON hr.employees TO report_user;SQL> GRANT SELECT ON hr.departments TO report_user;– 4. 验证用户权限
SQL> SELECT grantee, table_name, privilege
FROM dba_tab_privs
WHERE grantee = ‘REPORT_USER’;GRANTEE TABLE_NAME PRIVILEGE
———— ———— ———
REPORT_USER EMPLOYEES SELECT
REPORT_USER DEPARTMENTS SELECT

— 1. 修改用户密码
SQL> ALTER USER myapp IDENTIFIED BY NewApp123;User altered.

— 2. 修改用户表空间配额
SQL> ALTER USER myapp QUOTA 1000M ON users;User altered.

— 3. 锁定用户
SQL> ALTER USER report_user ACCOUNT LOCK;User altered.

— 4. 解锁用户
SQL> ALTER USER report_user ACCOUNT UNLOCK;User altered.

— 5. 删除用户
SQL> DROP USER report_user CASCADE;User dropped.