Kbase P108781: Permission error when running the application against a new SQL Server Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/11/2005 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL
MS SQL DataServer
SYMPTOM(s):
Permission error when running the application against a new SQL Server Database
The MS SQl Serverdatabase is created from the existing one
The new database is created from the existing database but only the name is different
The schema holder is also created from the existing one
The name of the schema holder is different
Using the same user that is accessing the old SQL Server database
CAUSE:
The user is not added to the new SQL Server Database created from the old one. Only the dbo user was listed under the new database users
FIX:
Add the user that is being used to access the SQL Server Database using the SQL Server Enterprise manager tool, and give all select, update and insert privileges to that user for the new database.