How to Give password to table in sql server

Posted by Shoyebaziz123 under Sql Server on 10/28/2013 | Points: 10 | Views : 1479 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi All,

In my application i need a table that can't be seen by any other , so i need a table that have a password , is it possible .

or in other case table must be readonly can't be editable , but from my code ( server side code ) record must be updatable .

please help

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 10/28/2013 [Member] [MVP] Platinum | Points: 25

0	You can set the roles and privileges to that table.... For server-side user you set all permissions and for other users set only SELECT permission on that table Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Shoyebaziz123, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 10/28/2013 [Member] [MVP] Platinum | Points: 25

0	In application disable EDIT link/button for the users... Can you elaborate the requirement? NOTE: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f171443f-1377-45b8-bb02-4ccf2b169efa/give-user-readonly-access-to-one-table-in-a-database Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Shoyebaziz123, if this helps please login to Mark As Answer. \| Alert Moderator

In application disable EDIT link/button for the users...

Can you elaborate the requirement?

NOTE:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f171443f-1377-45b8-bb02-4ccf2b169efa/give-user-readonly-access-to-one-table-in-a-database

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Shoyebaziz123, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts