postgre_sql 赋值权限

最新推荐文章于 2024-05-21 10:48:30 发布

Cincinnati_De

最新推荐文章于 2024-05-21 10:48:30 发布

阅读量592

点赞数

分类专栏：个人日记

本文链接：https://blog.csdn.net/Cincinnati_De/article/details/102604375

版权

个人日记专栏收录该内容

142 篇文章 4 订阅

订阅专栏


SELECT call_date, count(*)
	FROM dw.t1where black_status= true  
	group by call_date
order by 1  

10.0.0.92  port  5436     db：dbname   user: username  pw: userps

GRANT USAGE ON SCHEMA ods TO username  ;
GRANT USAGE ON SCHEMA dw TO username  ;
GRANT USAGE ON SCHEMA dm TO username  ;
--ods
grant select on ods.t1,ods.t2to  sipapp;
--dw
grant select on dw.t_dw_audio_call_list,
                dw.t_dw_audio_call_list,
				dw.t_dw_audio_ip_list,
				dw.t_dw_audio_merge,
				dw.t_dw_call_list,
				dw.t_dw_call_list_ct_jz_list,
				dw.t_dw_called_day,
				dw.t_dw_called_from_196mat
				to sipapp;

--dm
grant  select  on dm.t_dm_alarm_ip_stat,
                  dm.t_dm_alarm_tel_stat,
				  dm.t_dm_blak_ip,
				  dm.t_dm_blak_type,
				  dm.t_dm_level2_blak_ip,
				  dm.t_dm_sip_ip_scan,
				  dm.t_dm_sip_ip_scan_result,
				  dm.t_dm_search_excel,
				  dm.t_dm_search_excel_result
				to  app; 
grant  insert   on  dm.t_dm_search_excel to  username  ;
grant  insert,select   on  dm.t_dm_search_excel_result to  username  ;

GRANT  EXECUTE ON PROCEDURE dm.pro_dm_search(character varying) TO username   ;

GRANT  EXECUTE ON PROCEDURE dm.pro_dm_search(character varying, integer) TO username   ;