Skip to main content

db in single-user mode

  • September 30, 2013
  • 1 reply
  • 5 views

Pietro_La_Torre
Forum|alt.badge.img+2
Hi, is it possible to temporarily allow only one user to query the database ? thanks, Pietro.

1 reply

Navin_C
Forum|alt.badge.img+2
  • Participating Frequently
  • September 30, 2013
Hi Pietro, It will require manual intervention. Ask the DBA to temporarily revoke all access from all users and grant a SELECT / USAGE access to only one user required by you. when he temporary time is fulfilled then you can grant all the revoked access to all users again. You can make a script for this, once script is made, you can assign it to a CRON expression for the temporary time period' Hope this helps.