2.REVOKE 回收權限
REVOKE CONNECT, RESOURCE FROM 用戶名;
REVOKE SELECT ON 表名 FROM 用戶名;
REVOKE SELECT, INSERT, DELETE ON表名 FROM 用戶名1, 用戶名2;
查詢數(shù)據(jù)庫中第63號錯誤：
select orgaddr,destaddr from sm_histable0116 where error_code='63';
查詢數(shù)據(jù)庫中開戶用戶最大提交和最大下發(fā)數(shù)： select MSISDN,TCOS,OCOS from ms_usertable；
查詢數(shù)據(jù)庫中各種錯誤代碼的總和：
select error_code,count(*) from sm_histable0513 group by error_code order
by error_code;
查詢報表數(shù)據(jù)庫中話單統(tǒng)計種類查詢。
select sum(Successcount) from tbl_MiddleMt0411 where ServiceType2=111
select sum(successcount),servicetype from tbl_middlemt0411 group by servicetype
