Versions Compared

Old Version 10

changes.mady.by.user Former user

Saved on

compared with

New Version 11

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip
titleWhen to Organize using Databases

Documents can be organized into Archives in a database, with permissions to the Archives set by user or group of users. In many cases this level of document and security organization is enough and only one database is required.

There are times when more than one database may be recommended:

  • If, for security reasons, you wish to have separate access for a given department or division (such as the HR department).
  • If, for organizational purposes, you wish to simply the field catalogs, security options, and Archive setup.
  • If you have installed the default SQL Server Express® database software as part of your installation and the amount of data in the database is approaching the SQL Server Express limit of 10 GB.

With Windows® authentication, you must have a login into SQL Server to be able to create the database. If your Windows account does not have a SQL login, you must select SQL Authentication and provide SQL credentials. Databases are usually created by the user who did the installation. During the default Square 9 installation, when SQL Server Express was installed, a SQL login was created for the account. If GlobalSearch was installed for an existing SQL application, the account used to install GlobalSearch must have been created as a SQL login with a database creator role.


Tip
titlePlan Your Database Access

Check that that all database administrators have proper permissions – the database administrator must be a database user. Also, note that database access and database administration access for Square 9 Users can be granted, changed, and revoked only via the web client.

...