Database Privileges after splitting

[NoviceITGuy]

I have recently split my database using the database splitting wizard into a backend and a front end, I would like to give sepcial privileges to a few users , like some will just have write and read access and some users would have full access. I would appreciate if any one can guide me though the priviliges process when the data base has been split.

Thank you for your time.

 

[tonyireland]

There's no problem with this, it's an excellent idea but you need some code at startup which allows for the fact that the Backend may be unavailable or has moved
This article is useful in this regard

http://support.microsoft.com/default.aspx?scid=kb;en-us;209862