Post reply

SQL views

  • July 31, 2013 at 8:31 pm

    #280738

    Comments posted to this topic are about the item SQL views

    Best,
    Naseer Ahmad
    SQL Server DBA

  • July 31, 2013 at 10:58 pm

    #1637644

    Easy one for the day 🙂

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • July 31, 2013 at 11:34 pm

    #1637647

    kapil_kk (7/31/2013)

    Easy one for the day 🙂

    +1 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • August 1, 2013 at 12:03 am

    #1637653

    Thanks for the easy one Naseer!

    ~ Lokesh Vij

    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • August 1, 2013 at 12:43 am

    #1637658

    Thought this was a trick question for a minute!

  • August 1, 2013 at 12:51 am

    #1637660

    Easy one today, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 1, 2013 at 12:53 am

    #1637661

    Easy qotd, but explanation is really confused.

    Schemabinding doesn't hide the definition and users of the database could still view the definition if TDE is enabled.

    Why do you think that Schemabinding should hide the definition of the VIEW?

    TDE encrypts only data on storage, but "database user" can simply see them by a SELECT.

  • August 1, 2013 at 2:53 am

    This was removed by the editor as SPAM

  • August 1, 2013 at 3:02 am

    #1637690

    Nice one...

  • August 1, 2013 at 3:04 am

    #1637692

    Simple and good one....

  • August 1, 2013 at 3:25 am

    #1637697

    Easy one for the day

  • August 1, 2013 at 5:22 am

    #1637734

    Nice question and the answer was quite obvious. It should be pointed out though that just because you create a view WITH ENCRYPTION, it is still possible for users with the appropriate permissions to see the definition of the view. Also, WITH ENCRYPTION prevents the view from being published as part of SQL Server replication.

    See below for the documentation from MSDN

    [H3]http://msdn.microsoft.com/en-us/library/aa258253(v=sql.80).aspx[/H3]

    WITH ENCRYPTION

    Indicates that SQL Server will convert the original text of the CREATE VIEW statement to an obfuscated format. Note that obfuscated views can be reverse engineered because SQL Server must de-obfuscate views for execution. In SQL Server 2000, the obfuscated text is visible in the syscomments system table and may be susceptible to de-obfuscation attempts.

    Using WITH ENCRYPTION prevents the view from being published as part of SQL Server replication.

  • August 1, 2013 at 5:25 am

    #1637735

    Just to be clear, in my previous reply, the view definition in syscomments can be de-obfuscated in SQL Server 2000 for those of us who are still having to maintain very old systems that can only be run on SQL 2000. (Yes, we have two applications that our company depends upon that can only be run on SQL 2000). I would love to retire these systems but the powers that be in the company insist that we must keep these systems around because they find them so useful and are "deathly afraid of change".

  • August 1, 2013 at 6:32 am

    #1637751

    Good question!

  • August 1, 2013 at 7:09 am

    #1637776

    Thanks for the question.

    Here's an interesting read on the use of VIEW DEFINITION permissions instead of encryption.

    Options For Hiding SQL Server Code[/url]

    Enjoy!

Viewing 15 posts - 1 through 15 (of 24 total)

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