I am new to sql server, thought I have extensive experience (15 years) in all other major RDBMS's (Oracle, MySQL, Informix,...). But now I have to work with SQL server with which I have no experience. I am trying to learn the basics of sql server, I have
the following questions:
1> What is the difference between a database user and a database schema? which of these is the owner of a table? I mean, when we refer to a table using it's fully qualified name, is the table name prefixed with the schema name or the name of user who
2> Can a schema contain tables created by different users of the database?
3> When we use grant and revoke (for giving or denying permissions) statements, is the grantee a user or schema? that is, are permissions granted/revoked to/from users or schemas?
Can someone please reply to these questions? I will be highly thankful.
View Complete Post