Data Backup and Recovery Discussions

SMO shared profile for different users?

galchen

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.

2 REPLIES 2

sindhe

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

shetty

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

Login to the non-oracle user where the profile needs to be shared on HOST2

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.

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public