1

Topic: Display of a column by a role in a DB is closed

Greetings.
We have a table. TABLE1
In it of field ID, SUMMA, DATE
Field the total is visible in the event that role XX_INTERFACE_VIEW is given the user
Question: how it is made? Where in what tables to find this adjustment.
It is possible example how to find in what tables this data on adjustments?
fnd_roles - Here the role lies. It makes sense.
Remaining tables and Google so anything distinct did not tell. And it would be desirable to understand:
1. Where this adjustment physically lies.
2. How to do such restrictions on columns for a certain role.
In advance thanks for the answer.

2

Re: Display of a column by a role in a DB is closed

Sneaky Pete;
Looking than output of the rights is regulated. If means  - then to you prompt. And if it is self-written system of distribution of grants - that only to its author. For - it is a lot of implementation variants, and under this business - it is even more principles of the name of tables and functions.

3

Re: Display of a column by a role in a DB is closed

Kind  - Eh;
Oracle means. These are 100 %.

4

Re: Display of a column by a role in a DB is closed

Sneaky Pete;
I  knows nothing about the table fnd_roles. These are 100 %

5

Re: Display of a column by a role in a DB is closed

Sneaky Pete;
But if it is exact , GRANT SELECT [column list] On <table_name> and DBA_COL_PRIVS to you in the help

6

Re: Display of a column by a role in a DB is closed

Sneaky Pete;
Controlling the Display of Column Data with Policies , as a variant

7

Re: Display of a column by a role in a DB is closed

Kind  - Eh;
Was mistaken dba_roles certainly

8

Re: Display of a column by a role in a DB is closed

Kind  - Eh;
In DBA_COL_PRIVS it is empty

9

Re: Display of a column by a role in a DB is closed

Sneaky Pete wrote:

Greetings.
We have a table. TABLE1
In it of field ID, SUMMA, DATE
Field the total is visible in the event that role XX_INTERFACE_VIEW is given the user
Question: how it is made? Where in what tables to find this adjustment.
It is possible example how to find in what tables this data on adjustments?
fnd_roles - Here the role lies. It makes sense.
Remaining tables and Google so anything distinct did not tell. And it would be desirable to understand:
1. Where this adjustment physically lies.
2. How to do such restrictions on columns for a certain role.
In advance thanks for the answer.

fnd_roles Is OeBS?
If yes, there the system of access (responsibility)
You as try to get access to a column, what user come oebs or db?

10

Re: Display of a column by a role in a DB is closed

All thanks:) after dock understood. Thanks for dock.

11

Re: Display of a column by a role in a DB is closed

Vadim Lejnin;
I an error made it dba_roles certainly)

12

Re: Display of a column by a role in a DB is closed

To put it briefly, me misled.
In Dba_Policies in Function function which hid not a column has been specified, and simply restricted select under the table.
But me convinced, what exactly is not visible a column. I did not check up - began to search. And it appeared that a column received stupidly enclosed . Certainly it returned nothing.
Excuse that misled you.