Home Forums SQL Server 2005 SQL Server 2005 Security create Role and user RE: create Role and user

  • December 4, 2014 at 5:25 am

    #1762684

    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!