1

Topic: Privileges on specific c

How to give all  (Grant) on specific c to the specific user so that except this c on another c it did not have any privileges.
In advance

2

Re: Privileges on specific c

To launch this specific user under this specific circuit and not to produce the objective rights to objects of other circuits; system privileges - on need.

3

Re: Privileges on specific c

andrey_anonymous;
Only so and it is possible in such a way or for example

GRANT ALL PRIVILEGES ON <schema name> to <<user>>

Such syntax is or similar?

4

Re: Privileges on specific c

No

5

Re: Privileges on specific c

Goofy122 wrote:

andrey_anonymous;
Only so and it is possible in such a way or for example

GRANT ALL PRIVILEGES ON <schema name> to <<user>>

Such syntax is or similar?

Only objective
[spoiler approximately so:]

declare
cursor cur
is
select ' grant all on ' || owner || '. "' || object_name
|| ' "to ' || ' USER_NAME ' txt
from dba_objects
where o.owner = ' SCHEMA_NAME'
and object_type not in (' INDEX ', ' DATABASE LINK ', ' TRIGGER ')
and status = ' VALID ';
begin
for current_line in cur
loop
execute immediate current_line.txt;
end loop;
end;

[/spoiler]

6

Re: Privileges on specific c

Understood thanks

7

Re: Privileges on specific c

Goofy122 wrote:

understood thanks

and so after everyone new ddl

8

Re: Privileges on specific c

andreymx wrote:

it is passed...
And so after everyone new ddl

Not everyone