To register and use the Optim™ data
privacy user-defined functions (UDFs) for Microsoft™ SQL Server, your user ID must
be granted the appropriate privileges.
Note: It is recommended
that your site's database administrator (DBA)
install and configure the UDFs for SQL Server, since these tasks require
operating system access to the server machine and restarting the SQL
Server.
The DBA should already have the required permissions to create
and execute UDFs, which include the following privileges:
- CREATE ASSEMBLY
- Grants the authority to create a managed application module that
contains class metadata and managed code as an object in an instance
of SQL Server. By referencing this module, common language runtime
(CLR) functions, stored procedures, triggers, user-defined aggregates,
and user-defined types can be created in the database.
- CREATE FUNCTION
- Grants the authority to create a user-defined function in SQL
Server. The return value can either be a scalar (single) value or
a table.