December 29, 2008 at 9:30 pm
Hi
How to give a permission for change and modify table rows data.
My purpose is in my table has few columns.If admin insert record for my special table anyone cant modify or delete records in that table. how i can do this kind of work inside my tables.
My real plan is i want to maintain my stored procedure details in my special table. In this table people can check are there existing stored procedure name and it details.only This table can maintain single (authorize) person.
Ex- this is my table columns.
SP_Name Created_Date Table_Use Description Created_Person
Thanks all.
December 30, 2008 at 4:18 am
Maybe I misunderstand you, but if you want your users to be able to read data from the table and not modify the data, you can grant them read permissions only and deny them insert/update/delete on the table. The user that can modify the data can have read/update/insert/delete permissions without any deny permissions on the table. If I misunderstood you, can you pleas clarify your question?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 30, 2008 at 8:40 pm
ya thanks for reply. Your correct.That kind of thing i want to do. so how i do user permission for single table.can you send me more details or some useful url for get more idea.
Thank you
December 30, 2008 at 10:00 pm
In that case you just need to use grant statement. You can read about it on the internet or on you local copy of books on line at ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/c001c2e7-d092-43d4-8fa6-693b3ec4c3ea.htm
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply