How to get rid off it?

  • GSquared (11/29/2011)


    Charmer (11/29/2011)


    yeh...the thing which i am looking for is, how do they restrict a database for any alteration... ?

    because i could select and update any records...but i couldn't alter any columns...

    was it any account problem or can we restrict a database for multi-user like that..? that's what i am asking for?

    The data on that is answered in the articles I posted links for.

    It's very, very easy to grant the ability to read data, without granting anything else. Can be restricted to certain tables, even.

    yeah i saw the link.....Tnx buddy

    Thanks,
    Charmer

  • One more option that you can check is the below one

    Tools->Options->Designers->Table and Database Designers->Prevent saving changes that require table re-creation


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

Viewing 2 posts - 16 through 17 (of 17 total)

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