AnsweredAssumed Answered

technical article 35408

Question asked by jayasudha123 on Dec 12, 2014
Latest reply on Dec 15, 2014 by jayasudha123



I come across this article on providing grants to sde and other users.


▪ sys.dbms_lock

▪ sys.dbms_pipe

▪ sys.dbms_lob

▪ sys.dbms_sql

▪ sys.dbms_utility

▪ sys.utl_raw


I am working with SDE 10.1 direct connect to Oracle 11g.

What is the purpose of these grants ? Do we need to explicity grant or by default available ?

It is mentioned that these grants can't be given via role and should be provided to users.

If a user is assigned to a role, can we grant access to execute the packages directly to users ?