SecSQL is a framework for SQL databases that provides security at the row (record) level to any SQL database/application either at the design stage or post design for existing databases/applications.
Read access can be defined differently for each table in a database from
completely open, based on list of users and/or groups or completely closed.
Update access can also be defined differently for each table in a database,
independently from Read access, from completely open, based on list of users and/or
groups or completely closed.
Read and/or Update access can be applied across all tables in a database based
on list of users and/or groups defined for each user who is a creator of
records which is applied on top of table level Read/Update access.
security can be applied by limiting/allowing who can Create or Delete records
for each table and/or for specific users.
is additionally enforced by Company for use in situations such as hosted
environments or service providers that require fully segregated multi-company
databases/applications within the same SQL server.
number of procedures are provided which are callable from the application
databases enabling easy customisation/enhancements to the security access
provided by the framework for specific application requirements. i.e.
read/update access changing during approval process in a workflow
and Groups are defined once in the SecSQL Directory database and are accessed
by and maintained automatically across multiple application databases rather
than having to create separate security user/groups for each one.
setup and maintenance of security definition(s) for database/applications can
be managed by allocated users using standard SQL client software and/or WebDB
of SecSQL to an existing database is automated as far as possible by generating
and running the DDL scripts required automatically to add and modify the
database as required to utilise SecSQL.