Create new schema in PostgreSQL using DBeaver
At the beginning of my current job I had limited access to DB but recently my role is changed to superuser, admin, and owner. My colleague who was the previous DB admin is able to create a schema or change the permissions as there is a permission tab in the properties and he can change permissions by clicking easily. Would you please let me know how I can create schema and change permissions as well?
Why his dbeaver looks different from me? He can easily right click on the schema folder on top of all schemas on the left side column and select create new schema while I do not have that, like the following picture I found on the internet.
postgresql database-schema dbeaver
edited Nov 26 '18 at 11:24
a_horse_with_no_name
306k46468565
asked Nov 26 '18 at 10:28
SabaSaba
447
add a comment |
At the beginning of my current job I had limited access to DB but recently my role is changed to superuser, admin, and owner. My colleague who was the previous DB admin is able to create a schema or change the permissions as there is a permission tab in the properties and he can change permissions by clicking easily. Would you please let me know how I can create schema and change permissions as well?
Why his dbeaver looks different from me? He can easily right click on the schema folder on top of all schemas on the left side column and select create new schema while I do not have that, like the following picture I found on the internet.
postgresql database-schema dbeaver
edited Nov 26 '18 at 11:24
a_horse_with_no_name
306k46468565
asked Nov 26 '18 at 10:28
SabaSaba
447
What happens when you runcreate schemamanually? Maybe your database user doesn't have the necessary privileges
– a_horse_with_no_name
Nov 26 '18 at 10:30
@a_horse_with_no_name Thank you for your answer. I am able to do both creating schema and changing permissions manually but I want to do it by clicking as well. Would you please let me know if there is any queries that colleague can run to give me full access?
– Saba
Nov 26 '18 at 10:46
Sorry, no idea. I don't use DbSchema. But I only manage database objects through SQL statements (or scripts) anyway.
– a_horse_with_no_name
Nov 26 '18 at 11:00
add a comment |
At the beginning of my current job I had limited access to DB but recently my role is changed to superuser, admin, and owner. My colleague who was the previous DB admin is able to create a schema or change the permissions as there is a permission tab in the properties and he can change permissions by clicking easily. Would you please let me know how I can create schema and change permissions as well?
Why his dbeaver looks different from me? He can easily right click on the schema folder on top of all schemas on the left side column and select create new schema while I do not have that, like the following picture I found on the internet.
postgresql database-schema dbeaver
edited Nov 26 '18 at 11:24
a_horse_with_no_name
306k46468565
asked Nov 26 '18 at 10:28
SabaSaba
447
At the beginning of my current job I had limited access to DB but recently my role is changed to superuser, admin, and owner. My colleague who was the previous DB admin is able to create a schema or change the permissions as there is a permission tab in the properties and he can change permissions by clicking easily. Would you please let me know how I can create schema and change permissions as well?
Why his dbeaver looks different from me? He can easily right click on the schema folder on top of all schemas on the left side column and select create new schema while I do not have that, like the following picture I found on the internet.
postgresql database-schema dbeaver
postgresql database-schema dbeaver
edited Nov 26 '18 at 11:24
a_horse_with_no_name
306k46468565
asked Nov 26 '18 at 10:28
SabaSaba
447
edited Nov 26 '18 at 11:24
a_horse_with_no_name
306k46468565
asked Nov 26 '18 at 10:28
SabaSaba
447
edited Nov 26 '18 at 11:24
a_horse_with_no_name
306k46468565
edited Nov 26 '18 at 11:24
a_horse_with_no_name
306k46468565
edited Nov 26 '18 at 11:24
a_horse_with_no_name
306k46468565
306k46468565
asked Nov 26 '18 at 10:28
SabaSaba
447
asked Nov 26 '18 at 10:28
SabaSaba
447
asked Nov 26 '18 at 10:28
SabaSaba
447
447
What happens when you runcreate schemamanually? Maybe your database user doesn't have the necessary privileges
– a_horse_with_no_name
Nov 26 '18 at 10:30
@a_horse_with_no_name Thank you for your answer. I am able to do both creating schema and changing permissions manually but I want to do it by clicking as well. Would you please let me know if there is any queries that colleague can run to give me full access?
– Saba
Nov 26 '18 at 10:46
Sorry, no idea. I don't use DbSchema. But I only manage database objects through SQL statements (or scripts) anyway.
– a_horse_with_no_name
Nov 26 '18 at 11:00
add a comment |
What happens when you runcreate schemamanually? Maybe your database user doesn't have the necessary privileges
– a_horse_with_no_name
Nov 26 '18 at 10:30
@a_horse_with_no_name Thank you for your answer. I am able to do both creating schema and changing permissions manually but I want to do it by clicking as well. Would you please let me know if there is any queries that colleague can run to give me full access?
– Saba
Nov 26 '18 at 10:46
Sorry, no idea. I don't use DbSchema. But I only manage database objects through SQL statements (or scripts) anyway.
– a_horse_with_no_name
Nov 26 '18 at 11:00
What happens when you run
create schema manually? Maybe your database user doesn't have the necessary privileges– a_horse_with_no_name
Nov 26 '18 at 10:30
What happens when you run
create schema manually? Maybe your database user doesn't have the necessary privileges– a_horse_with_no_name
Nov 26 '18 at 10:30
@a_horse_with_no_name Thank you for your answer. I am able to do both creating schema and changing permissions manually but I want to do it by clicking as well. Would you please let me know if there is any queries that colleague can run to give me full access?
– Saba
Nov 26 '18 at 10:46
@a_horse_with_no_name Thank you for your answer. I am able to do both creating schema and changing permissions manually but I want to do it by clicking as well. Would you please let me know if there is any queries that colleague can run to give me full access?
– Saba
Nov 26 '18 at 10:46
Sorry, no idea. I don't use DbSchema. But I only manage database objects through SQL statements (or scripts) anyway.
– a_horse_with_no_name
Nov 26 '18 at 11:00
Sorry, no idea. I don't use DbSchema. But I only manage database objects through SQL statements (or scripts) anyway.
– a_horse_with_no_name
Nov 26 '18 at 11:00
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f53479140%2fcreate-new-schema-in-postgresql-using-dbeaver%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53479140%2fcreate-new-schema-in-postgresql-using-dbeaver%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
What happens when you run
create schemamanually? Maybe your database user doesn't have the necessary privileges– a_horse_with_no_name
Nov 26 '18 at 10:30
@a_horse_with_no_name Thank you for your answer. I am able to do both creating schema and changing permissions manually but I want to do it by clicking as well. Would you please let me know if there is any queries that colleague can run to give me full access?
– Saba
Nov 26 '18 at 10:46
Sorry, no idea. I don't use DbSchema. But I only manage database objects through SQL statements (or scripts) anyway.
– a_horse_with_no_name
Nov 26 '18 at 11:00