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



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

Which is the best place or learning center for MS SQL?????In Bangladesh?????

1 Answers   TCL, Wipro,


Define the one-to-one relationship while designing tables.

1 Answers  


What different steps will a sql server developer take to secure sql server?

1 Answers  


What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,


What is an index in a database?

1 Answers  


What is the system function to get the current user's user id?

3 Answers   TCS,


What is 4nf in normalization form?

1 Answers  


What is the meaning of resultset type_scroll_insensitive?

1 Answers  


create index a on employee(dno) In this,which index was created?

2 Answers  


What is instead of dml trigger?

1 Answers  


How can you insert null values in a column while inserting the data?

1 Answers  


Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  


Categories