Post reply

view defination

  • March 2, 2011 at 4:18 am

    #235402

    Hi all,

    how to give the permissions to user for view definition of Object in sql server 2008 r2

    Thanks to all

  • March 2, 2011 at 4:51 am

    #1293418

    I find Google quite useful when I can't remember the syntax of a command: http://www.mssqltips.com/tip.asp?tip=1593

  • April 12, 2011 at 7:13 pm

    #1310773

    GRANT VIEW DEFINITION

    Check this link:

    QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809

  • April 13, 2011 at 4:43 am

    #1310917

    I am not able to restrict user.

    He still able to see all the data.

  • April 13, 2011 at 5:58 am

    #1310959

    Is he a member of db_datareader? A member of db_owner? a member of sysadmin?

    Granting view definition doesn't remove permissions, it adds permissions

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 26, 2011 at 5:37 am

    #1315779

    If you want to restrict user can see only definition of the objects then remove all rights exclude public then give VIEW DEFINITION

    Regards,

    Syed Jahanzaib Bin Hassan

    MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog

    http://www.aureus-salah.com

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

Viewing 6 posts - 1 through 5 (of 5 total)

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