SQL Server Performance Forum – Threads Archive

transaction not commiting

i loged in as user1 and executed following query
use pubs
GO
create table emp(name varchar(5))
Go
*****************************************************
agan i logd in as user2 and issue following query
Use pubs
Go
select * from sysobjects where name=’emp’
emp1205579333U 2116106127360002005-02-24 16:35:28.31700 but when i gave
Use pubs
Go
select * from emp
m gettin error "invalid object ’emp’"
****************************************************
anyone hav any idea. whts the concept ?

I believe this is something realted to security. second user ,i think i have to give some privillage on database. pls wordout some comments .
Rajiv
SQL-DBA

Try:
select * from user1.emp

.. and reason being the object that are qualified with the name of the user who created the object. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>