Data cleansing Note: multiple users call the same function

Data cleansing Note: multiple users call the same function

Background]

During data extraction, when multiple users access different tables on the source end and need to use the same function, they need to create a new one under multiple users.

 

[Solution]

When multiple users use the same function, we can choose to recreate the function, but sometimes the execution is inconvenient due to too many functions, it is sometimes difficult for every user to manage functions once. Therefore, we can create the aggregate function and grant permissions to multiple users to use the same function. Take the isnum () function for example, the syntax is grant execute on user. function name to other users.

 

[Experiment]

Before granting permissions, log on to hyl and use the isnum function. The following error is returned:

Grant the isnum function execution permission of scott to the hyl user under sys, as follows:

SQL> grant execute on scott. isnum to hyl;

Use hyl again to call the isnum function. The verification is as follows:

Small knowledge, easy to remember.