-- oracle数据库 创建用户 并授权访问
create user USER_TEST_1 identified by USER_TEST_1; -- 创建用户 设置密码
grant connect to USER_TEST_1; -- 授权 连接
grant select on VM_ALARM_RECORD to USER_TEST_1; -- 授权 查询 VM_ALARM_RECORD(视图/表)USER_TEST_1(账号)
REVOKE select on VM_ALARM_RECORD FROM USER_TEST_1; -- 取消 授权
CREATE SYNONYM USER_TEST_1.VM_ALARM_RECORD FOR VM_ALARM_RECORD; -- 查询视图授权
create or replace view vm_alarm_record as select AJBH,JQBH from alarm_record_info -- 创建视图
select * from vm_alarm_record -- 查询 视图
创建数据库,创建用户,授权
CREATE DATABASE IF NOT EXISTS test DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
create user 'test'@'%' identified by 'test';
grant all privileges on oemc.* to 'test'@'%' identified by 'test';