root>sqlplus / as sysdba 用DBA的權限進入數(shù)據(jù)庫，需要創(chuàng)建一個賬戶 https://www.jb51.net/article/20367.htm
SQL>create user dbmonitor identified by "ty_sd_s"; 給賬戶授權 SQL>grant connect,resource to dbmonitor;
此賬戶執(zhí)行的腳本轉(zhuǎn)換成視圖
復制代碼 代碼如下:
SQL> drop view vstablespace; SQL> create view vstablespace as ( select a.tablespace_name "TABLESPACE", sum(a.bytes) SUM , sum(b.bytes) FREE , sum(b.bytes)/sum(a.bytes)*100 PRECENTFREE from dba_data_files a,dba_free_space b where a.file_id=b.file_id group by a.tablespace_name )
給用戶賦予select試圖的權限 SQL>grant select on vstablespace to dbmonitor ;
