- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: Database User- Rights
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-06-2013 01:53 AM
тАО11-06-2013 01:53 AM
Database User- Rights
Hello.
We got the problem, that the database user (domain user with admin rights on the db) launched a database shrink, which had caused a lock of the complete database. (which is shared with different sources / applications)
Which user rights are necessary for the HP SIM database to work properly?
BR
P.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-06-2013 04:54 AM - edited тАО11-06-2013 05:02 AM
тАО11-06-2013 04:54 AM - edited тАО11-06-2013 05:02 AM
Re: Database User- Rights
We found out that the mountpoint of the database was out of space.
Is there any way to prevent a automatically shrink of the HP SIM database?
Which user rights are necessary for the HP SIM database to work properly?
We have changed the right to read/write only for the sql db
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-06-2013 11:54 PM
тАО11-06-2013 11:54 PM
Re: Database User- Rights
Hello Pootch,
When you install SIM the databaserights need to be sysadmin for the instance where you install the database. When the database is installed you have db owner rights. What the minimal rights need to be is not clear but db owner sounds right.
Kind regards,
Andrew
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-18-2013 07:17 AM - edited тАО11-18-2013 07:18 AM
тАО11-18-2013 07:17 AM - edited тАО11-18-2013 07:18 AM
Re: Database User- Rights
Pootch-
yes, sql user should be a sysadmin at the time of SIM installation & then it can be downgraded to db owner to work HP SIM properly.
If my post was useful, please clik on "White Star" to award me kudos :)