What happens if you are trying to access a schema not owned by you?

Question Posted / sanjeev saxena

1 Answers
1033 Views
I also Faced
E-Mail Answers

What happens if you are trying to access a schema not owned by you?..

Answer / Kirti Raman

If you try to access a schema that is not owned by you in MS SQL Server, you will receive an error message: 'Cannot find the object "schemaName".', unless you have been granted explicit permissions on the objects within that schema.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL Server Interview Questions

How to create a trigger for insert only?

1 Answers

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

1 Answers

What do you mean by an execution plan? How would you view it?

1 Answers

from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers

What is the difference between OLEDB and ODBC

4 Answers CFCI,

What is the sql server agent?

1 Answers

How to loop through result set objects using odbc_fetch_row()?

1 Answers

Explain unique key in sql server?

1 Answers

What is the purpose of object explorer and its features? : sql server management studio

1 Answers

Describe how to use linked server?

1 Answers

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1 Answers

What are the types of containers in ssis?

1 Answers

For more SQL Server Interview Questions Click Here