Default access database

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  April 17, 2008 at 10:17 am

  #181540

  There is a group of users, who need to access mutiple databases in a server. The databases need to be refreshed regular basis.

  If the default access database is set to one of user-databases, the users will lose connection to the whole server when the use-database is refreshing (loading).

  If the default access database is set to one of system databases, say master, what disavantages we may have?

  Any input will be greatly appreciated in advance.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  April 17, 2008 at 4:55 pm

  #804055

  I like to use Tempdb as the default database. It's always there and there's nothing for a user to mess up.

  Greg