Restricting Permissions

  • 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:-)

  • Hi All,

    Could anyone please assist me with above scenorio.......:(

  • 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