What is achieved by the concept of Database users

[scottgymson]

Hi,
I can only see that databases and database users only
help in namespacing the objects.

I have tried creating two different users (u1 and u2) for a
login (server user) for two different databases (db1 and
db2).

u2 could access an object for which u1 was explicitly given
access permissions. u2 could drop an object owned by u1 as
well.

Can you please explain the purpose of databases and database
users if there is something other than namespacing?

Thanks,
Scott

[Chris N. Brown [Sybase, Inc.]]

Posted in the wrong group (try the ase administration group) but I'll
reply.

It's security, similar to what UNIX users (or even windows users) get
with their OS. You can keep individual users from accessing specific
tables (or performing DML operations on specific tables) or executing
stored procedures.

I normally see enterprises create "groups" (usually based in business
function), grant permissions to the group itself, and then add users to
the group. Keeps management easier.

HTH,
Chris