Willy Schroers wrote: > > Hello, > > I'm a it-student and currently working on the analyse part of > my final > examproject. > I'm developing a java based application and would like to use an > opensource database. > I have some experience with microsoft sqlserver and I would > like to know > if it would be difficult to use sapdb instead of mssql. > I have read some documentation about it and installed sapdb on redhat > 9.0. After that I created a database but I can't realy see > how it works > with users and roles. And if I create a table as user test in the sql > studio will this table be accessible for all users because it appears > under the user test in the treeview what realy differs from mssql?
Tables created by user x are not seen by any other user until those other users have received some privilege for this table. Granting privileges has to be done like this: GRANT ... ON <tablename> TO <userspec> <userspec> can be one specific user, several users or PUBLIC, where PUBLIC means: all user existing now and in the future. Roles on the other hand are collections of privileges, therefore even a role can be specified (if the role exists) in the <userspec> of the GRANT mentioned above and the whole role can be granted to users/roles/PUBLIC. But roles have to be enabled in the session where they should be used. Normal privileges are valid without explicit enabling. Elke SAP Labs Berlin > > Could someone help me with some information about it? Or send me some > url's of good documentation for application developers using sapdb. > > Kind Regards, > Willy Schroers > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
