Mixing
![Find $P(Y(x)gt E[Y(x)])$, where $Y(x)= min{i:X_igt x}$ for $(X_i)$ i.i.d.](https://lh4.googleusercontent.com/-ziKMfxhVtqM/AAAAAAAAAAI/AAAAAAAAAAA/APUIFaNd-1DR9XSdsIWQslvUTwy62NmtKw/s72-c-mo/photo.jpg?sz=32)
How to allow a user to see a subset of a table or view
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have a view in a private schema with several lets say company_id's. For a special use case I want to allow one company to see a subset of this table (for its own data). So I have create a role and a schema 'company_123' and I have created a view in this schema like
create view company_123.transactions_v as
select * from business.all_transactions_v
where company_id = 123;
But unfortunately this view is empty as the user 'company_123' has no select rights on the original view. How could I achieve this requirement?
postgresql permissions
asked Jan 3 at 10:57
KICKIC
2,92653066
add a comment |
I have a view in a private schema with several lets say company_id's. For a special use case I want to allow one company to see a subset of this table (for its own data). So I have create a role and a schema 'company_123' and I have created a view in this schema like
create view company_123.transactions_v as
select * from business.all_transactions_v
where company_id = 123;
But unfortunately this view is empty as the user 'company_123' has no select rights on the original view. How could I achieve this requirement?
postgresql permissions
asked Jan 3 at 10:57
KICKIC
2,92653066
I think you're going to need to give this user read permissions on the original underlying table(s) beneath the view. I doubt that Postgres security will let you hack around permissions by using views.
– Tim Biegeleisen
Jan 3 at 11:00
1
You need Row Security Policies.
– klin
Jan 3 at 11:02
add a comment |
I have a view in a private schema with several lets say company_id's. For a special use case I want to allow one company to see a subset of this table (for its own data). So I have create a role and a schema 'company_123' and I have created a view in this schema like
create view company_123.transactions_v as
select * from business.all_transactions_v
where company_id = 123;
But unfortunately this view is empty as the user 'company_123' has no select rights on the original view. How could I achieve this requirement?
postgresql permissions
asked Jan 3 at 10:57
KICKIC
2,92653066
I have a view in a private schema with several lets say company_id's. For a special use case I want to allow one company to see a subset of this table (for its own data). So I have create a role and a schema 'company_123' and I have created a view in this schema like
create view company_123.transactions_v as
select * from business.all_transactions_v
where company_id = 123;
But unfortunately this view is empty as the user 'company_123' has no select rights on the original view. How could I achieve this requirement?
postgresql permissions
postgresql permissions
asked Jan 3 at 10:57
KICKIC
2,92653066
asked Jan 3 at 10:57
KICKIC
2,92653066
edited Jan 3 at 11:02
KIC
asked Jan 3 at 10:57
KICKIC
2,92653066
asked Jan 3 at 10:57
KICKIC
2,92653066
asked Jan 3 at 10:57
KICKIC
2,92653066
2,92653066
I think you're going to need to give this user read permissions on the original underlying table(s) beneath the view. I doubt that Postgres security will let you hack around permissions by using views.
– Tim Biegeleisen
Jan 3 at 11:00
1
You need Row Security Policies.
– klin
Jan 3 at 11:02
add a comment |
I think you're going to need to give this user read permissions on the original underlying table(s) beneath the view. I doubt that Postgres security will let you hack around permissions by using views.
– Tim Biegeleisen
Jan 3 at 11:00
1
You need Row Security Policies.
– klin
Jan 3 at 11:02
I think you're going to need to give this user read permissions on the original underlying table(s) beneath the view. I doubt that Postgres security will let you hack around permissions by using views.
– Tim Biegeleisen
Jan 3 at 11:00
I think you're going to need to give this user read permissions on the original underlying table(s) beneath the view. I doubt that Postgres security will let you hack around permissions by using views.
– Tim Biegeleisen
Jan 3 at 11:00
1
1
You need Row Security Policies.
– klin
Jan 3 at 11:02
You need Row Security Policies.
– klin
Jan 3 at 11:02
add a comment |
1 Answer
1
active
oldest
votes
You will have to grant SELECT permissions to the user on your table.
You can slice the visible rows and columns to the user though and you should be able to solve your problem.
answered Mar 21 at 9:23
vishalv2050vishalv2050
367314
add a comment |
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%2f54020962%2fhow-to-allow-a-user-to-see-a-subset-of-a-table-or-view%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 will have to grant SELECT permissions to the user on your table.
You can slice the visible rows and columns to the user though and you should be able to solve your problem.
answered Mar 21 at 9:23
vishalv2050vishalv2050
367314
add a comment |
You will have to grant SELECT permissions to the user on your table.
You can slice the visible rows and columns to the user though and you should be able to solve your problem.
answered Mar 21 at 9:23
vishalv2050vishalv2050
367314
add a comment |
You will have to grant SELECT permissions to the user on your table.
You can slice the visible rows and columns to the user though and you should be able to solve your problem.
answered Mar 21 at 9:23
vishalv2050vishalv2050
367314
You will have to grant SELECT permissions to the user on your table.
You can slice the visible rows and columns to the user though and you should be able to solve your problem.
answered Mar 21 at 9:23
vishalv2050vishalv2050
367314
answered Mar 21 at 9:23
vishalv2050vishalv2050
367314
answered Mar 21 at 9:23
vishalv2050vishalv2050
367314
answered Mar 21 at 9:23
vishalv2050vishalv2050
367314
367314
add a comment |
add a comment |
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%2f54020962%2fhow-to-allow-a-user-to-see-a-subset-of-a-table-or-view%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
I think you're going to need to give this user read permissions on the original underlying table(s) beneath the view. I doubt that Postgres security will let you hack around permissions by using views.
– Tim Biegeleisen
Jan 3 at 11:00
1
You need Row Security Policies.
– klin
Jan 3 at 11:02