Hello,
I have a routine written under the sys schema but I forgot how to a apply it to a user schema.
In the create user statement?
In the create profile statement?
Thank You!
Printable View
Hello,
I have a routine written under the sys schema but I forgot how to a apply it to a user schema.
In the create user statement?
In the create profile statement?
Thank You!
Code:
ALTER PROFILE profile_name
PASSWORD_VERIFY_FUNCTION function_name;
ALTER USER user_name PROFILE profile_name;
Hope this would help you.
Sam