Create special OS user just for TP

[former_member61236]

Hi,

Attempting to create a user specifically for TP. I'm unable to use default (sid)adm due to some technical reasons.

Platform on AIX + Oracle 11

Done the following but still doesn't work

• Created OS user abcadm
• Created DB user "create user ops$abcadm identified externally"
• Grant DB user resource "grant dba,resource,sapdba,connect to ops$abcadm"

Some tips would be great!

Thanks

[former_member61236 · Accepted solution]

Great my DBA helped me out. Created the synonym for me. I can do R3trans -x now from abcadm

create synonym "OPS$ABCADM".SAPUSER for "OPS$(SID)ADM".SAPUSER;

[Former Member]

Hi Wei,

Good to hear that you have solved the issue.

But what about the files ownership?

Cheers,

Shahab

[former_member61236]

same OS group sapsys

[Former Member]

Hi Wei,

You need to use the <sid>adm for tp.

It is not possible to use other users See SNOTE 307122.

Cheers,

Shahab

[former_member61236]

Hi Shahab,

It should work if I've set the environment right under OS. Now I'm only lost in setting the right permission for Oracle.

Cheers,

WL

[former_member188883]

Hi Wei,

whats the issue in using sidadm user ? we can help in resolving the same. I do not see any benefit in created a special user to perform tp operations.

Regards,

Deepak Kori

[former_member61236]

Hi Deepak,

As mentioned not possible due to technical reasons.

Cheers,

WL