Kbase P140618: SQL Server stored procedures are not listed in the data dictionary
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/01/2009 |
|
Status: Unverified
SYMPTOM(s):
Using Data Dictionary cannot find SQL Server stored procedures
SQL Server login used to access the database does not have execute permissions on the database
While executing a stored procedure directly on SQL Server fails with access errors
FACT(s) (Environment):
Windows
CAUSE:
Reviewing access permissions on the login used to access the database objects such as stored procedures on SQL Server, the login had read-only access.
FIX:
Providing execute permissions to the login in SQL Server allows to list the stored procedure in the data dictionary.