MYSQL DEFINER

1. VIEW DEFINER 수정

ALTER DEFINER = '계정'@'localhost' VIEW 뷰 이름 AS 뷰 생성 쿼리

ALTER DEFINER = 'testtest'@'localhost' VIEW 뷰 이름 AS SELECT * FROM ~~~~~

예시)

ALTER DEFINER = 'root' view VI_ORGN_EMP_SESSION AS
SELECT	...

FROM 	...

 

2. 함수1개 Definer 수정

status; // 계정 접속상태 확인

show function status where db='DB명';
show procedure status where db='DB명';

select * from mysql.proc where definer='계정명@%' and type='function';
select * from mysql.proc where definer='계정명@%' and type='procedure';
		
UPDATE MYSQL.PROC SET DEFINER = 'newuser@%'  WHERE DEFINER='olduser@%' and type = 'FUNCTION';