angl

l2.sql

CREATE USER van_user1
IDENTIFIED BY pass;

CREATE USER van_user2
IDENTIFIED BY word;



CREATE ROLE van_role;
GRANT van_role TO van_user1, van_user2;

GRANT CONNECT TO van_role;
GRANT CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE PROCEDURE TO van_role;



GRANT SELECT ON VAN_8K51_INFO TO van_role;
GRANT EXECUTE ON UPD_BAT_STAT TO van_role;