Hello Amira,

synonyms is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.

You generally use synonyms when you are granting access to an object from another schema and you don’t want the users to have to worry about knowing which schema owns the object.

and here is the syntax to create synonym

CREATE [OR REPLACE] [PUBLIC] SYNONYM [schema .] synonym_name
FOR [schema .] object_name [@ dblink];

Example:

CREATE PUBLIC SYNONYM emps
FOR app.employees;

Hope this help.

Hi Sara,

you can use : fnd_user_pkg.ChangePassword API to change or reset password for any user from database like this:

[code]
DECLARE
l_user_name VARCHAR2(30):= UPPER(‘ORAASK’);
l_new_password VARCHAR2(30):= ‘welcome123’;
l_status BOOLEAN;
BEGIN
l_status := fnd_user_pkg.ChangePassword ( username => l_user_name,
newpassword => l_new_password);
—
IF l_status THEN
dbms_output.put_line (‘The password changed successfully for the User:’||l_user_name);
COMMIT;
ELSE
DBMS_OUTPUT.put_line (‘Unable to reset password due to’||SQLCODE||’ ‘||SUBSTR(SQLERRM, 1, 100));
ROLLBACK;
END IF;
—
END;
[/code]