I've been trying to play around with MSDE for a while now and still don't understand how to assign permissions to the database.
From what I've gathered on the subject, it does not support SQL authentication so any of the permissions assigned from with SQL itself do not have any effect whatsoever. Is this correct?
So I have to use the 'trusted connection' type connection where windows controls access to the SQL database. It seems that the only way I can currently get to use the database from a remote machine is if I log on with 'administrator' level permissions.
Obviously, I can't give everyone administrator level permissions, so what do I need to do so that I can let people with less than administrator permissions access the database.
Any help or suggestions is greatly appreciated!
Thanks in Advance,
Eddie
You can use sp_grantlogin system stored procedure to grant permission to other domain users. example: sp_grantlogin 'DOMAIN_NAME\username'. You can use it through sqlexec() function of VFP.
By the way you can customize your MSDE installation to use SQL Authentication during installation by putting this entry on the "Setup.ini": SECURITYMODE=SQL. For more information about customizing MSDE installation please go to this link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp. Note that you need to use "sp_addlogin" system stored procedure if you want create a user with SQL Server authentication. If you want you can create a utility to manage permission of your MSDE database.