> I can connect to the database using the DBA user, but I > cannot connect as > the new user I created (I get a -4008 invalid authorization) > > Question 1: What am I doing wrong? Did I forget to do > something? How do I > grant access to a database?
Users created with dbm are 'database manager operators'. You want to create a 'database users', which is done by connecting in SQLStudio with the DBA user und execting a CREATE USER statement. > Question 2: I set the database parameter RESTART_SHUTDOWN to > AUTO, but the > database did not start automatically. I set the database > instance service as > automatic instead and it works. Am I missing something? what is > RESTART_SHUTDOWN for? Without the RESTART_SHUTDOWN parameter, the database would only reach the administration mode when starting and would not shutdown cleanly when the operating system is stopped. > Question 4: If I have a remote client connecting to my > server, what port > should be open in the firewall? from etc/services: sql6 7210/tcp Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
