今日必須學完

 

User authority Level
L1	c_select,r_select
L2	c_select,r_select,r_update
L3	c_select,r_select,r_update,c_update,exe_procedure,seq_select,program_eep  [moto_role]
Privilege Explaination
c_select	sfis1 table select
c_update	sfis1 table dml(insert,update,delete)
r_select	sfism4 [emesc,emesp,emesad,sj,sajet] table select
r_update	sfism4 [emesc,emesp,emesad,sj,sajet] table dml(insert,update,delete)
moto_role	MERCURYPRODUCTION,MERCURYSTATIC,MOTO select,insert,update,delete
program_eep	EEP select,update,delete,insert
exe_procedure	execute procedure   SFIS1 [SFISM4, emesc,emesp,emesad,sj,sajet]
seq_select	all  sequence select
alter_procedure	execute procedure,compile procedure,alter procedure  (all procedure)
debug_procedure	execute procedure,compile procedure,alter procedure,debug procedure (all procedure)