Need info on LOB's and Permissions

[kewlcoder]

Hi,
I m kinda new to mysql, i want to know wat the equivalents to LOB's of oracle i mean we have clob and blob in oracle so wat do we have similar to that in Mysql,


And i notice after installation of mysql it is some thing like a raw database kinda thing... we got to create our own users and so... can you tell me how to create new users and wat tare the access permissions that i can use for common environments where i want to develope a client- server kinda environment. I mean some thing similar to 'grant'in oracle.

thank you,
kewlcoder.

 

[sleipnir214]

Assuming that "clob" is a contracted form of "character large object" and "blob" is the contracted form of "binary large object", then MySQL's equivalents are "text" and "blob", respectively. They are documented here:

http://www.mysql.com/doc/en/BLOB.html

MySQL supports a GRANT statement, too:

GRANT <permissions> on <dbname>.<tablename> to <userid>@<ip> identified by <password>

MySQL's GRANT command is documented here:

http://www.mysql.com/doc/en/GRANT.html

The one gotcha about MySQL's permission system is that user credentials consist of a 3-tuple of username, password, and IP address of connecting client. It's possible, for example, to set up a userid that requires a password to connect from 10.0.1.x and only grants permissions to a single table, but have that same username login without a password from 10.0.2.x and access all databases in the system.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[kewlcoder]

How about constraints, like we have the primary key constraint etc... and user defined ones......do we have any thing like that. and pls do tell me about triggers also if we do have any.

Kewlcoder.

 

[kewlcoder]

don't we hava any constraints kinda thing in mysql