| Schemas and Users [message #355381] |
Thu, 23 October 2008 19:58  |
dland
Messages: 2
Registered: October 2008
|
Junior Member |
|
|
Like many beginners, I find the whole schema vs. user thing a bit of confusing. Schemas are kind of like users and the two terms are often used interchangeably, but apparently they aren't quite the same thing. I have some specific questions:
1. Can you have more than one user for a schema? If not, how can you connect to the database with different privileges? Doesn't this become a security problem? Is it always up to the application code to make sure that users can't do things they aren't supposed to do?
2. Can you have one user that can access multiple schemas? E.g. can Joe access both the DataWarehouse and OnlineBookStore schemas?
3. Can you have a user with a different name than the schema (e.g. schema name = 'DataWarehouse' and user name = 'Joe')?
Thanks,
Dave
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
