New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ROLES & GRANT FOR VIEWS NOT WORKING [CORE93] #418
Comments
Commented by: Alice F. Bird (firebirds) Date: 2005-05-22 07:55 The issue is still present with FB2. Using the simplified
|
Commented by: Alice F. Bird (firebirds) Date: 2001-10-11 07:18 Unfortunately, Raf is correct. There's a bug in the way SET SQL DIALECT 3; /* CREATE DATABASE 'h:/temp/view_subsel.gdb' PAGE_SIZE 4096 /* Table: T, Owner: SYSDBA */ /* View: V1, Owner: SYSDBA */ /* View: V2, Owner: SYSDBA */ /* View: V3, Owner: SYSDBA */ /* View: V4, Owner: SYSDBA */ /* View: V5, Owner: SYSDBA */ /* Grant role for this database */ /* Role: RV, Owner: SYSDBA */ /* Grant permissions for this database */ |
Commented by: Alice F. Bird (firebirds) Date: 2001-08-20 08:47 Please Claudio give me an E-mail address where I can send Regards, |
Commented by: Alice F. Bird (firebirds) Date: 2001-08-17 15:22 To Claudio. I'm trying to mail directly to you but always
The following recipient(s) could not be reached:
delivery to this recipient. |
Commented by: Alice F. Bird (firebirds) Date: 2001-07-17 22:23 I had attached a backup off my DB (Empty), but it didn't |
Commented by: Alice F. Bird (firebirds) Reopened just to add attachment. |
Modified by: Alice F. Bird (firebirds)status: Closed [ 6 ] => Reopened [ 4 ] SF_ID: 442140 => resolution: Fixed [ 1 ] => |
Modified by: Alice F. Bird (firebirds)SF_ID: 442140 => summary: ROLES & GRANT FOR VIEWS NOT WORKING => ROLES & GRANT FOR VIEWS NOT WORKING |
Modified by: Alice F. Bird (firebirds)Attachment: empty.zip [ 10097 ] |
Modified by: Alice F. Bird (firebirds)status: Reopened [ 4 ] => Closed [ 6 ] resolution: Fixed [ 1 ] SF_ID: 442140 => |
Modified by: @pcisarWorkflow: jira [ 10117 ] => Firebird [ 14306 ] |
Modified by: @pavel-zotovQA Status: No test |
Submitted by: rafs (rafs)
Attachments:
empty.zip
SFID: 442140#
Submitted By: rafs
Please check why I'm getting error that i don't have
select rights on a
table when i select from a view who has select rights
on the table.
To Check te problem :
1. Restore the DB
2. Create a new user
3. Make the user member off CALS_USER
4. Login with that user and the role CALS_USER
5 Execute the following statement.
SELECT * FROM VW_OBJECTS.
I'm getting the following error : "No Select/Read
rights on table
catalog$lookup_info.
Why ?
Regards,
Raf Schandevyl
The text was updated successfully, but these errors were encountered: