Kbase P54048: Progress DB to MS SQL Server migration utility creates the t
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/10/2004 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
FACT(s) (Environment):
MS SQL 2000
SYMPTOM(s):
During the Progress DB to MS SQL Server migration the table owner in Microsoft SQL Server Database is created as dbo expecting a non-dbo user
The user is assign to the SQL Server Database and given the create table, view, stored procedure (SP), and function privileges in the Database right mouse click to Properties > Permissions tab.
The user, used in the ODBC connection to SQL Server Database, is granted the System Administrators server role in the SQL Server
CAUSE:
Revoke the System Administrators server role from the user.
The user is granted the System Administrators server role in the SQL Server. During the schema migration from Progress DB to MS SQL Server, SQL Server sees the user in the System Administrators role and changes the owner of the table to dbo so the other users with the System Administrators server role can also has the access to it.
FIX:
In order to revoke the System Administrators role follow the steps below:
1. Go to the SQL Server Enterprise Manager.
2. Console Root > Microsoft SQL Servers > SQL Server Group> Machine Name (Windows NT) > security > Logins
3. Select the user used in the ODBC connection and/or in the schema holder > right mouse click on the user to select properties > Click on Server roles tab
4. uncheck the System Administrators server role and click OK.