View - Create |
CREATE OR REPLACE VIEW ADMIN.v_security_users AS select name, description, priority, user_type from security_users where lower(security_users.database_login_id) = lower(user) WITH READ ONLY; grant select on v_security_users to full_access_user; create public synonym v_security_users for ADMIN.v_security_users; |