向其他Oracle用户授予存储过程权限 [英] Granting Rights on Stored Procedure to another user of Oracle

问题描述

我是一名本科生，在将用户A的所有权授予用户B在数据库Oracle 10g模式= xe中由用户B拥有的所有权时，我面临的问题很少.

I am a student of Undergraduate studies , and I am facing little problem in granting rights of ownership to a user A to a stored procedure being owned by user B in database Oracle 10g mode =xe.

请帮助我编写sql命令以将存储过程xyz的所有权授予另一个用户A.

Please help me in writing sql commands for granting rights of ownership on stored procedure xyz to another user A.

推荐答案

我不确定我是否理解您所说的所有权".

I'm not sure that I understand what you mean by "rights of ownership".

如果用户B拥有存储过程，则用户B可以授予用户A运行存储过程的权限

If User B owns a stored procedure, User B can grant User A permission to run the stored procedure

GRANT EXECUTE ON b.procedure_name TO a

然后，用户A将使用完全限定的名称(即

User A would then call the procedure using the fully qualified name, i.e.

BEGIN
  b.procedure_name( <<list of parameters>> );
END;

或者，用户A可以创建一个同义词，以避免必须使用完全限定的过程名称.

Alternately, User A can create a synonym in order to avoid having to use the fully qualified procedure name.

CREATE SYNONYM procedure_name FOR b.procedure_name;

BEGIN
  procedure_name( <<list of parameters>> );
END;

这篇关于向其他Oracle用户授予存储过程权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！