What is the minimum database access role SQL users need to discover the SQL Managed Object? (NETIQKB8851)

  • 7708851
  • 02-Feb-2007
  • 10-Dec-2010

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

What is the minimum database access role SQL users need to discover the SQL Managed Object?

Resolution

The minimum database role needed for SQL users to discover each SQL databases is 'public.'


Here are some of the SQL database access roles users need to execute certain tasks through SQL Knowledge Scripts:

  • db_ddladmin: Allow Knowledge Scripts to execute most of the extended stored procedures
  • db_backupoperator: Allow Knowledge Scripts to use DBCC command

Additional Information

Formerly known as NETIQKB8851