如何自动为特定用户角色提供授权以便频繁删除和创建表。 [英] How to provide grant to specific user role automatically for frequently drop and create table.

问题描述

我的数据库中有2个架构。其中一个模式有一个使用另一个模式表的包。来自另一个模式的表，经常在一段时间后丢弃并创建相同的名称。



因此，当表同时丢失包时由于该表，另一个模式将无效。



是否有任何方法可以提供授权访问权限，因为它在表格丢弃后或者自动重新编译该程序包的任何方式。请帮帮我。



在此先感谢。



我尝试过：



我还在找路。我正在寻找能够提供永久补助金的方式。 ：（

I Have 2 schema in my database. One of the schema has a package which is using a another schema's table. The Table from another schema, which is frequently drop and create with same name after a time span.

So, when the table has drop at the same moment the package from another schema will be invalid due the table.

Is there any way to provide a grant access will remain as it is after the table drop or any way to recompile automatically that package. Please help me on this.

Thanks in Advance.

What I have tried:

I am still finding a way. I am looking the way which will provide a permanent grant. :(

推荐答案

当您放弃对象时，权限也会被删除。这种情况总是发生。



另一方面，删除和重新创建对象应该是一种罕见的管理任务，而不是经常发生。特别是如果对象被其他对象（例如包）使用，则只有在数据库结构发生更改时才会发生这种情况。 。



因此，根据您的描述，我会尝试找到一种完全不同于改变永久物体的方法。

When you drop the object the privileges are also removed. This happens always.

On the other other hand dropping and re-creating an object should be a rare, administrative task and not to happen often. Especially if the object is used by other objects, for example packages, this should happen only if the structure of the database changes.

So based on your description, I'd try to find a completely different approach than altering the permanent objects.

这篇关于如何自动为特定用户角色提供授权以便频繁删除和创建表。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！