Bernhard S
Member³
Hello,
I wanted to create one user like another user and did that as system user. However sql/developer didn't show me an object priv on sys.v_$session, which is needed in our application to run.
I know that system cannot grant that priv anyway, but at least I expect it to show it and give out a message indicating that this priv should be granted as sys or something like that.
It shouldn't be necessary to create all users as sys, since for most privs that's not necessary.
Best regards,
Berny
I wanted to create one user like another user and did that as system user. However sql/developer didn't show me an object priv on sys.v_$session, which is needed in our application to run.
I know that system cannot grant that priv anyway, but at least I expect it to show it and give out a message indicating that this priv should be granted as sys or something like that.
It shouldn't be necessary to create all users as sys, since for most privs that's not necessary.
Best regards,
Berny