Sapdba_role in another user

[Former Member]

Good Day

I Have a distributed SAP system ECC 6.0 in HPUX 11.23.

In my database server the Oracle instances have a OSP name

I Install an Standalone Gateway in Database server call it SAG for configure my DB13 jobs in the CI Server.

I have my RFC configured correctly

In the database server

I configure the sagadm user environment, but I have problems with authorizations to run statistics.

I need run de sapdba_role.sql in the sagadm user.

My question is: This affect the operation of the oraosp user with brtools if I run this script in sagadm user?

In other words. Can I run brttols with booth users after run the script?

Regards

Miguel Angel

[Former Member]

Thank you everybody for the answers

1 I create ops$ user

sqlplus /nolog @ORADBUSR.SQL SCHEMAOWNER UNIX SBD x

2. Grant permits

sqlplus /nolog

connect/as sysdba

grant sapdba to ops$sbdadm;

3.

sqlplus /nolog @sapdba_role.sql SAPSR3

4. Configure the enviroment +

NLS_LANG=AMERICAN_AMERICA.UTF8

Thank a lot

Miguel Angel

[Former Member]

the standalone gateway on the DB instance should use the <SID>adm account.

then it will have the right environment, the right assignment to usergroups etc.

that's it.

Peter

[madhukara_shenoy]

Hi,

By running the sapdba_role.sql from the <sid>adm user shouldn't create any issue with the jobs running / scheduled from teh ora<sid> user.

At present, if you are running BR*tools from ora<sid> without any issue, by running the above scripts from the <sid>adm shouldn't create any issue for ora<sid> jobs

Regards,

Madhukar