What happens if you are trying to access a schema not owned by you?
Answer Posted / 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 View All Answers
What are the different subsets of sql?
What is normalization and what are the advantages of it?
Does view occupy space?
What is sql or structured query language?
How to remove duplicate rows from table except one?
Why we use the openxml clause?
How do I create a trace in sql server?
What is acid mean in sql server?
what is the difference between openrowset and openquery?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How raid can influence database performance?
What is standby servers? Explain types of standby servers.
How to convert character strings into numeric values?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are the source of constraints?