November 3, 2009 at 12:27 am
I am using Windows login.
I logged into server & working on column1 in Table1 in perticular DB.
Is there anyway that I can deny permissions to all people exept me in the network for that perticular column (Column1).
If the above Scenario is possible how can I get back the username who denied the permissions..
Thanks for your help:-)
November 3, 2009 at 11:37 pm
Hi All,
Could anyone please assist me with above scenorio.......:(
November 4, 2009 at 12:08 am
Go to database- security - double click on logins that you want to disable or deny permissions
go to securable- click on add-object type - select table- check on deny permission chose column permissions and select column
T-sql for it
use [Test_Repl]
GO
DENY UPDATE ON [dbo].[Emp] ([EmpName]) TO [test]
GO
use [Test_Repl]
GO
DENY UPDATE ON [dbo].[Emp] ([EmpName]) TO [test]
GO
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply