사용자, 역할 및 권한 명령¶ User, role, and privilege commands enable you to manage your users, roles, and privileges. 사용자 관리¶ CREATE USER ALTER USER DROP USER DESCRIBE USER SHOW USERS 프로그래밍 방식 액세스 토큰 관리¶ ALTER USER … ADD PROGRAMMATIC ACCESS TOKEN (PAT) ALTER USER … MODIFY PROGRAMMATIC ACCESS TOKEN (PAT) ALTER USER … ROTATE PROGRAMMATIC ACCESS TOKEN (PAT) ALTER USER … REMOVE PROGRAMMATIC ACCESS TOKEN (PAT) SHOW USER PROGRAMMATIC ACCESS TOKENS Workload identity federation management¶ SHOW USER WORKLOAD IDENTITY AUTHENTICATION METHODS 조직 사용자 관리¶ CREATE ORGANIZATION USER ALTER ORGANIZATION USER DROP ORGANIZATION USER SHOW ORGANIZATION USERS 조직 사용자 그룹 관리¶ CREATE ORGANIZATION USER GROUP ALTER ORGANIZATION USER GROUP DROP ORGANIZATION USER GROUP SHOW ORGANIZATION USER GROUPS 데이터베이스 역할 관리¶ CREATE DATABASE ROLE ALTER DATABASE ROLE DROP DATABASE ROLE SHOW DATABASE ROLES GRANT DATABASE ROLE REVOKE DATABASE ROLE GRANT DATABASE ROLE … TO SHARE REVOKE DATABASE ROLE … FROM SHARE 계정 수준 역할 관리¶ CREATE ROLE ALTER ROLE DROP ROLE SHOW ROLES USE ROLE USE SECONDARY ROLES GRANT ROLE REVOKE ROLE 권한 관리¶ GRANT <권한> … TO APPLICATION REVOKE <privileges> … FROM APPLICATION GRANT <권한> … TO APPLICATION ROLE REVOKE <privileges> … FROM APPLICATION ROLE GRANT <privileges> … TO ROLE REVOKE <privileges> … FROM ROLE GRANT <privileges> … TO USER REVOKE <privileges> … FROM USER GRANT <권한> … TO SHARE REVOKE <권한> … FROM SHARE GRANT OWNERSHIP GRANT CALLER REVOKE CALLER SHOW CALLER GRANTS SHOW GRANTS