Re: Permissions as a query?

#1

The Pervaqsive database supports TCP connections, and these should be
used by default. Make sure that you can PING the server by name before
trying to use it. Many NetWare sites do not have a proper DNS setup to
allow name resolution, which causes TCP connections to fail.

See the manual for the security stuff. A full SQL security layer is
implemented once you enable it, although the commands are a bit
different. Once security is enabled through the GUI, you can use SQL
scripts to set up users & rights:
GRANT LOGIN TO 'user':'password'
GRANT ALL ON * TO 'user'

Trying to do from memory, so check the SQL Reference manual for exact
syntax.
BB

seetickets wrote:

Quote:

Howdy people,

We are currently setting up pervasive SQL v9.5 on netware and I
wondered if any of you people would be kind enough to answer a few of
my questions?

Does anybody know if it's possible in Pervasive SQl to Grant user
access to a specific table on a database via an SQL query Like you
would in mySql?

I.e. in mySql I would usually do something like:

"GRANT ALL ON testdatabase.* TO user@localhost IDENTIFIED BY
(old_password('mypassword'))"

Also (Tell me if I'm being dumb here) can I connect over IP to our
pervasive database rather like mySql?

Cheers!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Permissions as a query?

comp.databases.btrieve comp.databases.btrieve

Re: Permissions as a query? - 09-20-2006 , 11:04 AM