Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Introduction : DataServer components : Security : MS SQL Server database security
 
MS SQL Server database security
As noted previously, you should follow the security guidelines that your MS SQL Server data source has established for your applications. The MS SQL Server database might require that all users supply a valid login name and password to access it. Data source access security typically has four levels:
*System administrator — Grants or revokes permissions to other users to create or own a wide type of objects; for example, databases
*Database owner — Grants other users permission to access or modify a database or its objects
*Database object owner — Defines a user who can be the owner of objects in a database owned by another user
*Public owner — Allows access to public database objects by any users without restriction