create Role and user

  • Hi All

    I have facing problem in following scnario create the role of sqlserver.

    In my datatabase i create a one user role for specifically denying one column for select permission .

    But that denying permission reflecting for multiple columns (two additional columns)

  • Post your script please.

    -- Gianluca Sartori

  • an issue with denying a column explicitly, is the end user cannot do a select * from a table (nor an application) using that person's credentials.

    it can make data access quite a bit more challenging.

    any query that selects that column in it will fail(ie select col1,col2,col3 from table)

    where col3 is explicitly denied.

    the code has to explicitly select the columns that are accessible.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply