BirkhoffКоннектится же как то диско к EUL, даже если у пользователя нет прав на чтение его таблиц.Коннектится то он коннектится, но только к базе. А EUL как такового не видит, если у данного пользователя нет прав на таблицы данного EUL.
Не видит EUL - означает, что нельзя выбрать данный EUL по умолчанию в пункте меню Инструменты => Опции => Закладка EUL.
Ну и соответсвенно не можем просмотреть ни какие рабочие книги из данного EUL (хотя в администраторе данному пользователю права на рабочие книги данны.)
BirkhoffКогда EUL создается есть галка Grant access to public.
Это наверное оно.Интересно что будет если ее не ставить.Если галку Grant access to public не ставить, то в этом случаи никакие права роли PUBLIC выдаваться не будут. И соотвественно, ни какой пользователь кроме владельца EUL, данный EUL видеть не будет.
Если же галку Grant access to public ставить то роли PUBLIC выдаются следущие права:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
grant DELETE on EUL5_ACCESS_PRIVS to public;
grant INSERT on EUL5_ACCESS_PRIVS to public;
grant SELECT on EUL5_ACCESS_PRIVS to public;
grant UPDATE on EUL5_ACCESS_PRIVS to public;
grant SELECT on EUL5_APP_PARAMS to public;
grant SELECT on EUL5_ASMP_CONS to public;
grant SELECT on EUL5_ASMP_LOGS to public;
grant SELECT on EUL5_ASM_POLICIES to public;
grant SELECT on EUL5_BAS to public;
grant DELETE on EUL5_BATCH_PARAMS to public;
grant INSERT on EUL5_BATCH_PARAMS to public;
grant SELECT on EUL5_BATCH_PARAMS to public;
grant UPDATE on EUL5_BATCH_PARAMS to public;
grant DELETE on EUL5_BATCH_QUERIES to public;
grant INSERT on EUL5_BATCH_QUERIES to public;
grant SELECT on EUL5_BATCH_QUERIES to public;
grant UPDATE on EUL5_BATCH_QUERIES to public;
grant DELETE on EUL5_BATCH_REPORTS to public;
grant INSERT on EUL5_BATCH_REPORTS to public;
grant SELECT on EUL5_BATCH_REPORTS to public;
grant UPDATE on EUL5_BATCH_REPORTS to public;
grant DELETE on EUL5_BATCH_SHEETS to public;
grant INSERT on EUL5_BATCH_SHEETS to public;
grant SELECT on EUL5_BATCH_SHEETS to public;
grant UPDATE on EUL5_BATCH_SHEETS to public;
grant SELECT on EUL5_BA_OBJ_LINKS to public;
grant DELETE on EUL5_BQ_DEPS to public;
grant INSERT on EUL5_BQ_DEPS to public;
grant SELECT on EUL5_BQ_DEPS to public;
grant UPDATE on EUL5_BQ_DEPS to public;
grant DELETE on EUL5_BQ_TABLES to public;
grant INSERT on EUL5_BQ_TABLES to public;
grant SELECT on EUL5_BQ_TABLES to public;
grant UPDATE on EUL5_BQ_TABLES to public;
grant DELETE on EUL5_BR_RUNS to public;
grant INSERT on EUL5_BR_RUNS to public;
grant SELECT on EUL5_BR_RUNS to public;
grant UPDATE on EUL5_BR_RUNS to public;
grant SELECT on EUL5_DBH_NODES to public;
grant DELETE on EUL5_DOCUMENTS to public;
grant INSERT on EUL5_DOCUMENTS to public;
grant SELECT on EUL5_DOCUMENTS to public;
grant UPDATE on EUL5_DOCUMENTS to public;
grant DELETE on EUL5_DOC_FOLDERS to public;
grant INSERT on EUL5_DOC_FOLDERS to public;
grant SELECT on EUL5_DOC_FOLDERS to public;
grant UPDATE on EUL5_DOC_FOLDERS to public;
grant DELETE on EUL5_DOMAINS to public;
grant INSERT on EUL5_DOMAINS to public;
grant SELECT on EUL5_DOMAINS to public;
grant UPDATE on EUL5_DOMAINS to public;
grant DELETE on EUL5_ELEM_XREFS to public;
grant INSERT on EUL5_ELEM_XREFS to public;
grant SELECT on EUL5_ELEM_XREFS to public;
grant UPDATE on EUL5_ELEM_XREFS to public;
grant DELETE on EUL5_EUL_USERS to public;
grant INSERT on EUL5_EUL_USERS to public;
grant SELECT on EUL5_EUL_USERS to public;
grant UPDATE on EUL5_EUL_USERS to public;
grant SELECT on EUL5_EXPRESSIONS to public;
grant SELECT on EUL5_EXP_DEPS to public;
grant SELECT on EUL5_FREQ_UNITS to public;
grant SELECT on EUL5_FUNCTIONS to public;
grant SELECT on EUL5_FUN_ARGUMENTS to public;
grant SELECT on EUL5_FUN_CTGS to public;
grant SELECT on EUL5_FUN_FC_LINKS to public;
grant SELECT on EUL5_GATEWAYS to public;
grant SELECT on EUL5_HIERARCHIES to public;
grant SELECT on EUL5_HI_NODES to public;
grant SELECT on EUL5_HI_SEGMENTS to public;
grant SELECT on EUL5_ID_SEQ to public;
grant SELECT on EUL5_IG_EXP_LINKS to public;
grant SELECT on EUL5_IHS_FK_LINKS to public;
grant SELECT on EUL5_KEY_CONS to public;
grant SELECT on EUL5_OBJS to public;
grant SELECT on EUL5_OBJ_DEPS to public;
grant SELECT on EUL5_OBJ_JOIN_USGS to public;
grant DELETE on EUL5_PLAN_TABLE to public;
grant INSERT on EUL5_PLAN_TABLE to public;
grant SELECT on EUL5_PLAN_TABLE to public;
grant UPDATE on EUL5_PLAN_TABLE to public;
grant DELETE on EUL5_QPP_STATS to public;
grant INSERT on EUL5_QPP_STATS to public;
grant SELECT on EUL5_QPP_STATS to public;
grant UPDATE on EUL5_QPP_STATS to public;
grant DELETE on EUL5_SEGMENTS to public;
grant INSERT on EUL5_SEGMENTS to public;
grant SELECT on EUL5_SEGMENTS to public;
grant UPDATE on EUL5_SEGMENTS to public;
grant SELECT on EUL5_SEQUENCES to public;
grant SELECT on EUL5_SQ_CRRLTNS to public;
grant SELECT on EUL5_SUB_QUERIES to public;
grant SELECT on EUL5_SUMMARY_OBJS to public;
grant SELECT on EUL5_SUMO_EXP_USGS to public;
grant SELECT on EUL5_SUM_BITMAPS to public;
grant SELECT on EUL5_SUM_RFSH_SETS to public;
grant SELECT on EUL5_VERSIONS to public;
