A profile may be associated with multiple account strings.
What is the query to know the various account strings associated with a particular profile?
Thanks in Advance!!
If I want to modify the account string of a profile (need to remove '&S' from account string because of excessive logging which is impacting system performance),which all DBC tables needs to be updated/modified?
No DBC table needs to be updated (in fact you can't update those tables directly).
You simply run a
MODIFY PROFILE myProfile AS ACCOUNT = ('aaa','bbb','bbb');
Of course you should have some documentation where the current settings for myProfile are noted.
Otherwise to get the current account strings (similar to Rglass query):
WHERE UserOrProfile = 'Profile'
AND UserName = 'myProfile'
How do we change the AccountName in dbc.dbase if the account is modified using the 'MODIFY PROFILE' command.I checked the explain for Modify Profile command , but DBC.Dbase is not updated.