Browsing Solutions For FCInter

  • Details about create_employee on Microsoft SQL Server

    The create_employee API within the Interfaces toolkit (fcinter) is used to create new users/employees in the system. As Clarify uses the database for storing and validating user logins and passwords, part of the create_employee API is creating a user and login at the database level as well. In Microsoft SQL Server 7 and 2000, the proper way to do this is using the sp_adduser and sp_addlogin system stored procedures, which the API does. However, sp_adduser requires that the executing user be a DBO (database owner). When using Dovetail Admin (fcAdmin) to create a new employee, the application user (meaning the user defined in the fc.env file) is the user connecting to the database, and this is the user who would be executing sp_adduser and sp_addlogin. So, if you will be using fcAdmin for creating employees, be aware that the user defined in fc.env should be a DBO. If the application user does not have proper permissions, the database will throw an error, such as: User does not have permission to perform this action As of SQL Server 2005, there are two new features available: CREATE USER and CREATE LOGIN. These functions replace the sp_adduser and sp_addlogin features. According to http://msdn2.microsoft.com/en-us/library/ms143729.aspx, sp_adduser and sp_addlogin are supported in the next version of SQL Server (2008), but will be removed in a later version. The specific version of SQL Server has not been determined. These new CREATE functions allow finer grain security access control, so the executing user does not need to be a DBO, but the user does need db_securityadmin and db_accessadmin roles.