Hello!

I'm using NHibernate along with a MS SQL Server 2005 database.

I am now trying to map the users registered for that db, as I stored some application relevant settings for each specific user in some tables, which I want to be able to read for the current application's user.

I however have some trouble getting started with that. After doing some research (scratching only the surface of the problem), I mapped sys.database_principals.

My questions are:
Is this the correct thing to map for my intentions?
Is the field "principal_id" the correct choice for my primary key?

I am sorry, should a question this specific to SQL Server belong somewhere else!

Cheers
Benjamin