Hi eddy, Thanks man...
Can you clear me on this line...
Ps: you can also put a windows user/usergroup in a SQLServer group (db_datareader,..)
MW, Excellent...
Very clear on this...a real time example...although i am single but i can understand..
So it's like a pair ( husband and wife ).
The following syntax will explain this properly.
CREATE USER brian_hippo FOR LOGIN "Andromeda\Brian_Hippo"
you said...
Let me explain one more topic.
What is a SCHEMA ? A schema is a logical namespace.
What does that mean ?
A schema is like a folder in windows. Allows you to organize your objects together.
Can you clear me how schema owns the security level...
I mean to say how it works for security level point of view..
Is there any relationship between schema and users....
And more thing Can Role can be assign user level or not....?
Cheers!
Sandy..
--