As part of my database administration policy, I have one login (i.e., admin) to create the tables and another login (i.e., user) to access them. Right now, I find myself having to manually set access permissions for the user login once NHibernate generates my tables (having connected as admin).
Is there a way to automate that? I am thinking of select/insert/update/delete permissions on the various tables, and was wondering if there was a way to associate them with each class. I've been using NHibernate.Mapping.Attributes to define my schema.
Thanks,
Gene
|