Is SQL Server Access like Oracle ?

[Dagon]

Anyone here who happens to know SQL Server as well as Oracle ?

I'm an Oracle DBA who's been put in a rather absurd position. I have to extract data from a SQL Server database but I've been told that I can only have read access to the database. Unfortunately, there is no-one in the company with the skills to set this up. The only way I can have the access is if I can tell them how to do it !

I can see the tables on the test database through MS Access and there they appear as:

<dbo.table_name>

I assumed that SQLServer is like Oracle and I have generated a script containing lots of lines of the type:

grant select on table to user;

and sent it to the &quot;DBA&quot;. But when he runs it, he gets the error &quot;invalid object name&quot;. I told him to try logging on as the user who owns the tables but he said that wasn't a real user.

Can anyone tell me what I need to do to get this working ? Would it help if I put &quot;dbo.&quot; in front of the table names ?

 

[DanZeMan]

Similar to Oracle, you need to prefix the schema on SQL Server objects, so yos, putting the dbo in front should fix your problem.
If any tables contain spaces then use the following syntax:
[dbo].[table name with spaces]