Jaise James
Reputable Poster
For some reason my post from th morning is gone.
I am trying to look into a solution whereby I can avoid giving public role access to all the database table in SQL sever.
I would like to work with a security model where only the table owner ( Proddta etc) or proxy user (PSFT) have access to table. and I would remove the security from Public to these tables.
Has any one done this . What were the downsides of this approach. Does any one have any other suggetion to achive this.
Appeicate your comments and helpful suggestion
We are e810 on Sql with Win2003 app servers
I am trying to look into a solution whereby I can avoid giving public role access to all the database table in SQL sever.
I would like to work with a security model where only the table owner ( Proddta etc) or proxy user (PSFT) have access to table. and I would remove the security from Public to these tables.
Has any one done this . What were the downsides of this approach. Does any one have any other suggetion to achive this.
Appeicate your comments and helpful suggestion
We are e810 on Sql with Win2003 app servers