Oracle DB Tablo ve Fonksiyon Yetkilendirme

Fonksiyon yetkilendirmesi….

GRANT EXECUTE ON [FONKSİYON ADI ] TO [KULLANICI_KODU];   /*  FONSİYONLARA YETKI VERMEK İÇİN */

Tablo yetki vermek için kullanılan kod

GRANT SELECT ON [TABLO_ADI] TO [KULLANICI_KODU];

To grant the SELECT privilege on table t to the authorization IDs maria and harry, use the following syntax:

GRANT SELECT ON TABLE t TO maria,harry

To grant the UPDATE and TRIGGER privileges on table t to the authorization IDs anita and zhi, use the following syntax:

GRANT UPDATE, TRIGGER ON TABLE t TO anita,zhi

To grant the SELECT privilege on table s.v to all users, use the following syntax:

GRANT SELECT ON TABLE s.v to PUBLIC

To grant the EXECUTE privilege on procedure p to the authorization ID george, use the following syntax:

GRANT EXECUTE ON PROCEDURE p TO george

To grant the role purchases_reader_role to the authorization IDs george and maria, use the following syntax:

GRANT purchases_reader_role TO george,maria

To grant the SELECT privilege on table t to the role purchases_reader_role, use the following syntax:

GRANT SELECT ON TABLE t TO purchases_reader_role

To grant the USAGE privilege on the sequence generator order_id to the role sales_role, use the following syntax:

GRANT USAGE ON SEQUENCE order_id TO sales_role;

To grant the USAGE privilege on the user-defined type price to the role finance_role, use the following syntax:

GRANT USAGE ON TYPE price TO finance_role;