Tuesday, February 4, 2014

create a user for Oracle Enterprise Manager or EM

Sometime many oracle newbies have difficulties creating a user in oracle with EM access. However in this post I try to provide you the instruction for performing such an operation.
create user john identified by abc;
grant create session,connect to john;
grant select_catalog_role, select any dictionary to john;
         Then connect as normal

These statements create a user with a minimal privilege required to login into the EM.

No comments:

Post a Comment