topic Re: SMO shared profile for different users? in Data Protection

SMO shared profile for different users?

galchen — Thu, 05 Jun 2025 07:21:08 GMT

Hi,

Can anyone tell if it is possible to create/attached the same profile to different users in a way that all the desired users will be working with the same profile/repository view?

regards,

Erez.

Re: SMO shared profile for different users?

sindhe — Wed, 02 Dec 2009 07:18:44 GMT

No, You can't have same profile with multiple users

While creating profile, you need to assign respective user also.

profile create -profile <profile_name> [-profile-password <profile_password>] -repository -dbname <repo_service_name> -host <repo_host> -port <repo_port> -login -username <repo_username> -database -dbname <db_dbname> -host <db_host> [-sid <db_sid>] [-login -username <db_username> -password <db_password> -port <db_port>

Regards,

Rajarao

Re: SMO shared profile for different users?

shetty — Wed, 02 Dec 2009 11:55:05 GMT

Hi Erez,

Profile can be attached to multiple users by setting the smo repository & host credentials.

eg: SMO repository is created on HOST1 under the repo_user@REPODB schema

If a profile is created as PRD_PROFILE of the target database PRD on HOST2 as oracle user the same can be accessed by any other user on the host by

executing the

smo credential set -host -name host2 -username non-oracle-user -password <password>

smo credential set -host -name host1 -username <username> -password <password>

Note: Provide the a valid O/S user credentials of the repository host (HOST1).

smo credentilal set -repository -dbname REPODB -host HOST1 -login -username repo_user -password <repo_password> -port 1521

smo credential set -profile -name PRD_PROFILE -password <password>

-Praveen.