-- 使用SQL*Plus連接到數(shù)據(jù)庫(kù)
sqlplus sys as sysdba
-- 或者使用其他工具如SQL Developer連接

CREATE USER my_user 
IDENTIFIED BY my_password 
DEFAULT TABLESPACE users 
TEMPORARY TABLESPACE temp;

-- 分配CONNECT和RESOURCE角色
GRANT CONNECT, RESOURCE TO my_user;

-- 分配特定的系統(tǒng)權(quán)限
GRANT CREATE SESSION TO my_user;
GRANT CREATE TABLE TO my_user;
GRANT CREATE VIEW TO my_user;
GRANT CREATE PROCEDURE TO my_user;
GRANT CREATE SEQUENCE TO my_user;

-- 分配特定的對(duì)象權(quán)限
GRANT SELECT, INSERT, UPDATE, DELETE ON my_schema.my_table TO my_user;

ALTER USER my_user QUOTA 100M ON users;

-- 鎖定用戶(hù)賬戶(hù)
ALTER USER my_user ACCOUNT LOCK;

-- 解鎖用戶(hù)賬戶(hù)
ALTER USER my_user ACCOUNT UNLOCK;

-- 連接到數(shù)據(jù)庫(kù)
-- sqlplus sys as sysdba

-- 創(chuàng)建用戶(hù)
CREATE USER my_user 
IDENTIFIED BY my_password 
DEFAULT TABLESPACE users 
TEMPORARY TABLESPACE temp;

-- 分配CONNECT和RESOURCE角色
GRANT CONNECT, RESOURCE TO my_user;

-- 分配特定的系統(tǒng)權(quán)限
GRANT CREATE SESSION TO my_user;
GRANT CREATE TABLE TO my_user;
GRANT CREATE VIEW TO my_user;
GRANT CREATE PROCEDURE TO my_user;
GRANT CREATE SEQUENCE TO my_user;

-- 分配特定的對(duì)象權(quán)限
GRANT SELECT, INSERT, UPDATE, DELETE ON my_schema.my_table TO my_user;

-- 為用戶(hù)分配表空間配額
ALTER USER my_user QUOTA 100M ON users;

-- 解鎖用戶(hù)賬戶(hù)
ALTER USER my_user ACCOUNT UNLOCK;

-- 確認(rèn)用戶(hù)創(chuàng)建和權(quán)限分配成功
SELECT username, account_status FROM dba_users WHERE username = 'MY_USER';

-- 使用新用戶(hù)連接到數(shù)據(jù)庫(kù)
sqlplus my_user/my_password@your_database

-- 創(chuàng)建一個(gè)表
CREATE TABLE test_table (id NUMBER, name VARCHAR2(50));

-- 插入數(shù)據(jù)
INSERT INTO test_table (id, name) VALUES (1, 'Test Name');

-- 查詢(xún)數(shù)據(jù)
SELECT * FROM test_table;

-- 刪除表
DROP TABLE test_table;