johanvr
asked on
Privileges
How do you grant create function privileges on a view ?
ASKER
ok, let me start with this , how do i grant create function privileges ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
to create functions you need only create procedure privilege,
create any procedure privilege, let you to create procedure on others
schema that you don't own.
create any procedure privilege, let you to create procedure on others
schema that you don't own.
Assuming you have scott user and you want to create a function.
1) login as DBA user
2) and issue the following command:
grant create procedure to scott;
bye
edwin
1) login as DBA user
2) and issue the following command:
grant create procedure to scott;
bye
edwin
Force accepted
** Mindphaser - Community Support Moderator **
** Mindphaser - Community Support Moderator **
create funcion privileges are granted to a user or role not a view.