SAP - MS SQL Users ?

[former_member312761]

Hi,

On each server SAP, instance DB (MS SQL Server 2005 or 2008) in the SAP database users (eg. PRD),iI see a DB user with the same name as the SID of the system, or PRD.

Is it necessary, not sufficient <SID>ADM and SAPService<SID>? something will happen if i block this DB user ?

regards,

T.

[Former Member]

Hi Tomasz,

the <sid> user in the <SID> database is the owner of all objects used by SAP, therefore you cannot block/lock/remove it if you want your system to work.

Please also see:

SAP Note 592514   - MSSQL: internal database users, permissions and security

SAP KBA 1645041 - Changing the password of a MS SQL Server Login in SAP environment

These clarify in more detail which users and logins are used and what you can / should not do with them.

Regards,

Beate

[former_member188883]

Hi,

Ideally in MSSQL "dbo" is the owner of system tables in the database and <SID> or <SAPSID> will be owner of SAP tables created in the database.

Using user SAPService<SID> SAP application makes connection to database on Windows environment.

Hope this information is useful.

Regards,

Deepak Kori

[Former Member]

That user is the 'owner' of sap data tables or in other words the 'SAP SCHEMA' user.

Please do not block that user and read documentation about what is a database schema and what is it's significance.

If you block that, SAP will not work.

Thanks