[SQL] DCL

資料控制語言 (Data Control Language)

 

GRANT 的語法結構為：

GRANT [權限] ON [要授予權限的資料庫物件] TO [使用者帳戶名稱] WITH [授權選項]

 

DENY 的語法結構為：

DENY [權限] ON [要授予權限的資料庫物件] TO [使用者帳戶名稱]

 

權限：
CONNECT

SELECT

INSERT

UPDATE

DELETE

EXECUTE

USAGE

REFERENCES

[SQL] 子查詢 sub query

select *
from(

select EMPLOYEE_ID,user_id,user_name,score
from table1
where seq = '27' or seq = '28'

) a
where score<>0
order by user_id