sys_ini.sql

来自「公安户口管理系统公安户口管理系统公安户口管理系统公安户口管理系统公安户口管理系统」· SQL 代码 · 共 26 行

CREATE USER ZK IDENTIFIED BY dragonsoft DEFAULT 
TABLESPACE GADATA TEMPORARY TABLESPACE TEMPORARY_DATA 
PROFILE DEFAULT ACCOUNT UNLOCK;

GRANT CONNECT TO ZK;

ALTER USER ZK QUOTA UNLIMITED ON GADATA;

CREATE ROLE zk_role NOT IDENTIFIED;

grant zk_role to zk;

grant create procedure to zk_role;
grant create snapshot to zk_role;
grant create any table to zk_role;
grant create view to zk_role;
grant create any index to zk_role;
grant create trigger to zk_role;

grant drop any procedure to zk_role;
grant drop any snapshot to zk_role;
grant drop any table to zk_role;
grant drop any view to zk_role;
grant drop any index to zk_role;
grant drop any trigger to zk_role;