oracle数据库 创建用户 并授权访问

-- 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';