vi   create_user_common.sql 

create ls policy  iqdm_iqmeta_edwdm_logical_server_policy

dqp_enabled=0

login_redirection=on

redirection_waiters_threshold=3

temp_data_in_shared_temp=off

create logical server  iqdm_iqmeta_edwdm_logical_server  membership (iqdm_s01,iqdm_s05)

policy iqdm_iqmeta_edwdm_logical_server_policy ;

create  login policy LGP_iqdm_iqmeta_edwdm

max_connections=30

max_failed_login_attempts=unlimited

password_life_time=600

default_logical_server=iqdm_iqmeta_edwdm_logical_server

create user iqmeta_edwdm identified by iqmeta@edwdm123 ;

set option  iqmeta_edwdm.default_dbspace='scm' ;

grant role SELECT_CATALOG to iqmeta_edwdm;   

 ----   SELECT_CATALOG  是一个人为定义的role .    
select  'grant select on  '  ||U.name||'.'||O.name||'   to SELECT_CATALOG ; '  from  SYSOBJECTS  O, SYSUSERS  U  where O.uid=U.uid  and  U.uid=0  ;     

grant  role  PUBLIC   to    SELECT_CATALOG ;  
------- 

# alter login policy LGP_iqdm_iqmeta_edwdm  add logical server iqdm_iqmeta_edwdm_logical_server ;    ---- 不需要 

alter user iqmeta_edwdm login policy LGP_iqdm_iqmeta_edwdm ;