Highlighted
Absent Member.. Absent Member..
Absent Member..
79 views

Least User Permissions type to discover MSSQL and Oracle DBs

Hello expert,

 

Our cusomer says that the SQL required permissions document for MSSQL server it appears that only sysadmin can execute some of these functions.

 

So they want to know whether HP has least permissions type of script to apply to the sql user.

 

Regarding oracle,  it looks like the same is true. So they require a high level of access.

 

 Is there anything less than DBA role can work for oracle?

 

Thanks in Advance,

  Rashmi Jathan

0 Likes
2 Replies
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: Least User Permissions type to discover MSSQL and Oracle DBs

The short answer is no.

 

A bit more complicated depends on what you're trying to discover. If you'd like to see that host X running MS SQL or Oracle DB, you should not use *Topology by SQL at all. Any "Host R&A by*" will do the magic.

If you would like to know what tablespaces, schemas and/or users defined on the instance, the permissions requested is the only way to go.

Regards
-Dmitry Gomel, PMP
Click the Like button at the bottom to say 'Thanks'.
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Least User Permissions type to discover MSSQL and Oracle DBs

Thanks Dmitry,

 

Is there default Predefined Role in Oracle or MSSQL that HP suggests can be provided by the DB team in order to meet the Topology discovery permission requirement?

 

Thanks,

   Rashmi Jathan

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.