Required privileges for database consistency checks
To use the database consistency checker, the AR System database user (ARAdmin) must have correct privileges to the system view, stored procedures, or table that is used to get table information. If the BMC Remedy AR System database user does not have sufficient privileges, checkdb cannot fetch table information from the database to validate it.
For SQL, grant permission for the AR System database user as follows:
- SQL — Grant permission to sp_MShelpcolumns