Por default não é permitido conceder ou revogar grants para uma procedure no banco de dados Oracle além de EXECUTE e DEBUG. No entanto, caso aja a necessidade de visualizar o conteúdo de uma procedure, você poderá criar uma view e conceder o grant de select com a opção de grant na view criada. Com isso, segue os passos:
- Criação de uma view com a opção de consulta no campo text da dba_source (caso deseja visualizar todo o conteúdo do objeto e não somente o texto, você poderá colocar o * ao invés do campo mencionado):
create view SELPROC as select text from dba_source where TYPE='PACKAGE BODY' and owner='owner here'; SQL> select distinct(TYPE) from dba_source; TYPE ------------ TYPE BODY PROCEDURE TYPE LIBRARY FUNCTION TRIGGER PACKAGE BODY PACKAGE 8 rows selected.
- Conceder o grant de consulta na view ao usúario que deseja consultar o conteúdo da package:
grant select on SELPROC to your_account with grant option;
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.