How to give a database access to specific users only?

• ssandeepv

  SSC Rookie

  Points: 37

  More actions

  September 1, 2010 at 1:20 pm

  #237758

  I want to lock a database and restrict access to all the users. Is there any sql query so that any user can run it and the database opens only for that particular user?

  Thanks,

  Sandeep.

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  September 1, 2010 at 1:50 pm

  #1215267

  Duplicate post...this post already has response

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton