Oracle user - read only to any tables
I'm trying to add a user with read-only permissions to all tables. The problem is that after connecting to the database by SQL Developer, the tables (empty tab) do not appear on this user. Select on tables only works after adding the schema name. for example, schema_name.table_name.
What I've done:
CREATE USER user IDENTIFIED BY pass;
GRANT CONNECT TO user;
GRANT CONNECT, RESOURCE to user;
GRANT CREATE SESSION TO user;
GRANT SELECT ANY TABLE TO user;
What else should I do?
user sqldeveloper
edited Jan 17 at 12:40
Romeo Ninov
1,83421014
asked Jan 17 at 8:02
user986263user986263
61
add a comment |
I'm trying to add a user with read-only permissions to all tables. The problem is that after connecting to the database by SQL Developer, the tables (empty tab) do not appear on this user. Select on tables only works after adding the schema name. for example, schema_name.table_name.
What I've done:
CREATE USER user IDENTIFIED BY pass;
GRANT CONNECT TO user;
GRANT CONNECT, RESOURCE to user;
GRANT CREATE SESSION TO user;
GRANT SELECT ANY TABLE TO user;
What else should I do?
user sqldeveloper
edited Jan 17 at 12:40
Romeo Ninov
1,83421014
asked Jan 17 at 8:02
user986263user986263
61
add a comment |
I'm trying to add a user with read-only permissions to all tables. The problem is that after connecting to the database by SQL Developer, the tables (empty tab) do not appear on this user. Select on tables only works after adding the schema name. for example, schema_name.table_name.
What I've done:
CREATE USER user IDENTIFIED BY pass;
GRANT CONNECT TO user;
GRANT CONNECT, RESOURCE to user;
GRANT CREATE SESSION TO user;
GRANT SELECT ANY TABLE TO user;
What else should I do?
user sqldeveloper
edited Jan 17 at 12:40
Romeo Ninov
1,83421014
asked Jan 17 at 8:02
user986263user986263
61
I'm trying to add a user with read-only permissions to all tables. The problem is that after connecting to the database by SQL Developer, the tables (empty tab) do not appear on this user. Select on tables only works after adding the schema name. for example, schema_name.table_name.
What I've done:
CREATE USER user IDENTIFIED BY pass;
GRANT CONNECT TO user;
GRANT CONNECT, RESOURCE to user;
GRANT CREATE SESSION TO user;
GRANT SELECT ANY TABLE TO user;
What else should I do?
user sqldeveloper
user sqldeveloper
edited Jan 17 at 12:40
Romeo Ninov
1,83421014
asked Jan 17 at 8:02
user986263user986263
61
edited Jan 17 at 12:40
Romeo Ninov
1,83421014
asked Jan 17 at 8:02
user986263user986263
61
edited Jan 17 at 12:40
Romeo Ninov
1,83421014
edited Jan 17 at 12:40
Romeo Ninov
1,83421014
edited Jan 17 at 12:40
Romeo Ninov
1,83421014
1,83421014
asked Jan 17 at 8:02
user986263user986263
61
asked Jan 17 at 8:02
user986263user986263
61
asked Jan 17 at 8:02
user986263user986263
61
61
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You should add also:
grant select any dictionary to user;
to give user permission to get from dictionaries the list of tables
ALso is possible to grant to this user privilege to read catalogs:
grant SELECT_CATALOG_ROLE to user;
answered Jan 17 at 8:15
Romeo NinovRomeo Ninov
1,83421014
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1395262%2foracle-user-read-only-to-any-tables%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You should add also:
grant select any dictionary to user;
to give user permission to get from dictionaries the list of tables
ALso is possible to grant to this user privilege to read catalogs:
grant SELECT_CATALOG_ROLE to user;
answered Jan 17 at 8:15
Romeo NinovRomeo Ninov
1,83421014
add a comment |
You should add also:
grant select any dictionary to user;
to give user permission to get from dictionaries the list of tables
ALso is possible to grant to this user privilege to read catalogs:
grant SELECT_CATALOG_ROLE to user;
answered Jan 17 at 8:15
Romeo NinovRomeo Ninov
1,83421014
add a comment |
You should add also:
grant select any dictionary to user;
to give user permission to get from dictionaries the list of tables
ALso is possible to grant to this user privilege to read catalogs:
grant SELECT_CATALOG_ROLE to user;
answered Jan 17 at 8:15
Romeo NinovRomeo Ninov
1,83421014
You should add also:
grant select any dictionary to user;
to give user permission to get from dictionaries the list of tables
ALso is possible to grant to this user privilege to read catalogs:
grant SELECT_CATALOG_ROLE to user;
answered Jan 17 at 8:15
Romeo NinovRomeo Ninov
1,83421014
answered Jan 17 at 8:15
Romeo NinovRomeo Ninov
1,83421014
answered Jan 17 at 8:15
Romeo NinovRomeo Ninov
1,83421014
answered Jan 17 at 8:15
Romeo NinovRomeo Ninov
1,83421014
1,83421014
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1395262%2foracle-user-read-only-to-any-tables%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
