Enforce fully qualified table name in Slick Query

How to enforce slick to add schema name in generated query so that it works with different db users.

I have two users one have all privileges while other is read only. I have granted select on user 1's tables to user 2.

But, on running query in Slick, encountered error ORA-00942: table or view does not exist.

Please suggest.

Answers


Figured it out. Table allows to pass schema name as given below

         abstract class Table[T](_tableTag: Tag, _schemaName: Option[String], _tableName: String) 

Example

            class InstrumentType(tag: Tag) extends 
                Table[String](tag,Some(SCHEMA_NAME), TableName)

Need Your Help

How to disable default css in KendoUI?

javascript jquery html css kendo-ui

In my application I use global definitions CSS for "INPUT", "SELECT", etc. and when I try use KendoUI widgets, I have problem with formatting - KendoUI widget use my default style CSS.

How to get variable upper in the code

php mysql variables position

I have a MySQL query in the <body> section of my website. I get certain variables with it - $power, $poles and so on.