Member since
12-05-2016
13
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1313 | 12-06-2016 06:26 AM |
12-07-2016
12:44 AM
I take it from this that there is a difference between Table level selection and All column level selection. Perhaps that acts a little bit like an "SELECT ... WITH GRANT" on the object (Teradata SQL).
... View more
12-06-2016
11:48 AM
@jss thankyou for the tip. I was indeed required to execute an SQL DSL to GRANT SELECT on the employee TABLE. I was then required to GRANT CREATE on default DATABASE to USER. Which obeys ANSI I guess, but it seems adding the resource level privilege by Ranger is not sufficient (and I expect not with Atlas either with a tag). Interestingly from a SQL perspective even though the user creates the view, he needs to be explicitly provided GRANT SELECT on the object they create, which you don't need to do in Teradata SQL.
... View more
12-06-2016
11:12 AM
I have been validating the Ranger options. I have select on all columns of a hive table: SELECT ssn, name, location FROM employee; works, however the following does not: CREATE VIEW employee_v AS SELECT ssn, name, location FROM employee; fails due to not having SELECT on "employee". So confused... thoughts? org.apache.hive.service.cli.HiveSQLException: Error while compiling
statement: FAILED: HiveAccessControlException Permission denied: user
[raj_ops] does not have [SELECT] privilege on [default/employee]
... View more
Labels:
- Labels:
-
Apache Hive
12-06-2016
06:26 AM
After backworking the dependencies I restarted HBase and then restarted Atlas - it was then all systems go. Unfortunately Ambari warnings didn't report the Hbase error.
... View more
12-06-2016
05:54 AM
Using Sandbox, allocated 8GB RAM on a 16GB computer (SSD). Infra/Hbase/Kafka turned on In Atlas UI I'm able to add tags, but searching within the search tab feature (both full text and at attribute level) fails. Has anybody else had this problem? Is there a fix?
... View more
Labels:
- Labels:
-
Apache Atlas