our database used to query data is SQL database. the database and table design is given by the vendor. the owner of the table is not dbo but a created user (ABC). so when my dba created a login for me, he give me the username with highest privilleges that is ABC. i created the connection in designer and use BO to generate report and no issue.
when my user create a another user login which is only a read only, my universe can’t work as it will mention invalid object name… what i found out is if your username is the creator(ABC), all the sql can be run without the alias in front of the table (example select * from [table] or select * from ABC.[table] can be run). but when you change the username to read only then select * from [table] will not be able to run and you need select * from ABC.[table].
now all my script from the universe is unable to run as it dos not have the user alias in front of the table…
another to add… whenever we look at the script generated from the universe in bo, i found the script without the owner name (ABC.[]) and without the “With (nolock)” statement.
i would like to know if the script the universe generated is nolock or lock statement and i would like to know how i can put the owner name and “With (nolock)” statement at the script generated by the universe.
as far as I know for SQL server to add no locks to the tables, there is no direct way. What you can do is create views based on the tables
like
Select * from table1 with (nolock)
and use views in the universe instead of tables.
when i change the “rename table” and put the owner as “ABC” and qualifier as blank and save, then object name will become ABC.ABC.[column] in the object properties. why is the owner repeated twice??