I come across this article on providing grants to sde and other users.
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 ?