Meu problema é o seguinte, na procedure add_role_select o usuário é adicionado normalmente, mas nas outras da o seguinte erro: admin option not granted for role!
E quando uso a procedure
add_profile_user
da o sequinte erro: missing user or role name.
CREATE OR REPLACE PACKAGE BODY pck_username_oracle IS
------------
--CRIA USUÁRIO ORACLE
PROCEDURE cria_username_oracle(p_username VARCHAR2
,p_senha VARCHAR2) IS
BEGIN
--
EXECUTE IMMEDIATE 'CREATE USER ' || p_username || ' IDENTIFIED BY ' || p_senha;
--
END cria_username_oracle;
------------
--ALTERA SENHA DO USUÁRIO ORACLE
PROCEDURE altera_senha_username_oracle(p_username VARCHAR2
,p_senha VARCHAR2) IS
BEGIN
--
EXECUTE IMMEDIATE 'ALTER USER ' || p_username || ' IDENTIFIED BY ' || p_senha;
--
END altera_senha_username_oracle;
------------
--ADD USUÁRIO NAS ROLES
PROCEDURE add_role_select(p_username VARCHAR2) IS
BEGIN
EXECUTE IMMEDIATE 'GRANT role_select TO ' || p_username;
END add_role_select;
--
PROCEDURE add_role_update(p_username VARCHAR2) IS
BEGIN
EXECUTE IMMEDIATE 'GRANT role_update TO ' || p_username;
END add_role_update;
--
PROCEDURE add_role_insert(p_username VARCHAR2) IS
BEGIN
EXECUTE IMMEDIATE 'GRANT role_insert TO ' || p_username;
END add_role_insert;
--
PROCEDURE add_role_delete(p_username VARCHAR2) IS
BEGIN
EXECUTE IMMEDIATE 'GRANT role_delete TO ' || p_username;
END add_role_delete;
--
PROCEDURE add_profile_user(p_username VARCHAR2) IS
BEGIN
EXECUTE IMMEDIATE 'alter user ' || p_username || ' profile GRAFICO';
END add_profile_user;