Kbase P115104: Do I need user level SELECT privilege to system tables to create schema holder?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/09/2008 |
|
Status: Verified
GOAL:
Do I need user level SELECT privilege to system tables to create schema holder?
GOAL:
What privileges are required on the system tables to SQL Server DataServer schema holder?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
MS SQL DataServer
Windows NT 32 Intel/Windows 2000
MS SQL
FIX:
No, you do not require user level SELECT privilege to the system tables to create schema holder on SQL Server database. The user inherits the SELECT privilege on the system tables through the stored procedures the DataServer runs as a result of the ODBC API calls. This behavior is unique to Microsoft SQL Server Database.