Results 1 to 9 of 9

Thread: Daffodil DB: Secured solutions for all enterprise needs.

  1. #1
    Join Date
    Jun 2004
    Location
    India
    Posts
    8

    Thumbs up Daffodil DB: Secured solutions for all enterprise needs.

    Daffodil DB: Secured solutions for all enterprise needs.

    The security aspect has always been a matter of prime concern for the enterprises. While designing Daffodil DB these concerns have been optimally addressed. Daffodil DB provides comprehensive security measures to ensure security and consistency for the client applications. A brief list of security measures can be described as follows

    1.Authentication

    Daffodil DB supports the provision of creating separate user accounts for different users. This helps in providing conditional access based upon the type of the user, usage requirements, and security provisions of the enterprise.

    2.Roles

    A role is a collection of privileges grouped under a single name. Instead of granting privileges to individual users, the Database Owner grants them a role. This role, in turn, is granted to the users that need the corresponding privileges.

    3. Using Views to Manage Privileges
    Rather than granting users privileges on a particular table, you can give them access to a view of the table. With the help of Daffodil DB Database owners can create views containing particular fields of a table and assign them to particular users. In this way the users can get a view of the data contained in a particular table but the data is secured as the users cannot change it.

    4. Object Privileges for the users and roles

    Daffodil DB permits users and roles to allow specific privileges to different users for restricting or providing the access to different database tables or objects. A user or role may access an object once it has been granted the necessary privilege. If it tries to perform an action for which it does not have the necessary privilege, Daffodil DB generates an error. These measures can be used conditionally to ensure security and consistency.

    5. Using Stored Procedures to Manage Privileges

    Through stored procedures you can restrict the database operations that users can perform. You can allow them to access data only through procedures that execute with the definer's privileges. For example, you can allow users to access a procedure that updates a table, but not grant them access to the table itself. When a user invokes the procedure, the procedure executes with the privileges of the procedure's owner. Users who have only the privilege to execute the procedure (but not the privileges to query, update, or delete from the underlying tables) can invoke the procedure, but they cannot manipulate table data in any other way.

    Daffodil DB allows users and roles to provide execution rights to other users and roles. This feature helps the users and roles to share procedures with others. Without proper rights no user or role will be able to execute a procedure. This feature is directed towards encouraging sharing security.

    6.Data Encryption

    A secure database environment would not be complete without consideration of encryption technology. The term encryption refers to the practice of obscuring the meaning of a piece of information by encoding it in such a way that it can only be decoded. To ensure a tight leashed security, Daffodil DB supports various encryption algorithms. The users can encrypt the data before storing them in a table with the help of a particular algorithm. Daffodil DB uses the following encryption algorithms to secure the data i.e. Blowfish, aes, tea, des, two fish, des3, and idea. Users can specify any of these algorithms for encryption while creating the database.

    All these measures should be used collectively to provide an effective security mechanism for a Daffodil DB database.

    For more information and support regarding any issue related to Daffodil DB visit us at http://www.daffodildb.com

  2. #2
    Join Date
    Jun 2004
    Location
    India
    Posts
    8

    Thumbs up Error using Clob Datatype

    hi ,

    I am having trouble using clob data type. when i enter any value in this field they show some thing like com.daffodilwoods.rmi.a_1942@2c45b65 .

    Is this a bug or i am using the datatype in a wrong way?
    please help me this is really bothering me.

  3. #3
    Join Date
    Jun 2004
    Posts
    5

    Thumbs up

    hi ,


  4. #4
    Join Date
    Jun 2004
    Posts
    5

    Thumbs down Re: Error using Clob Datatype

    Sol.

    Hi ,

    This is not a bug, you are definitely using the clob field in a wrong manner.

    The following program demonstrates how to use clob fields:

    private void clobUsage(Connection con) {

    try {
    Statement stt = con.createStatement();
    String createTable = "create table clobTable( columnOne clob)";
    dropTable(stt,"clobTable");
    stt.execute(createTable);
    InputStream tempStream = getClass().getResourceAsStream("DaffodilDBReadMe.t xt");
    InputStreamReader reader = new InputStreamReader(tempStream);
    PreparedStatement ps = con.prepareStatement(
    "insert into clobTable values(?)");
    for (int i = 0; i < 1; i++) {
    ps.setCharacterStream(1, reader, tempStream.available());
    // ps.setAsciiStream(1, tempStream, tempStream.available());
    ps.executeUpdate();
    }
    ResultSet rs = stt.executeQuery("select * from clobTable");
    while (rs.next()) {
    for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
    Clob clob = rs.getClob(i);
    Reader read = clob.getCharacterStream();
    String text = null;
    if (read != null) {
    CharArrayWriter writer = new CharArrayWriter();
    char[] buf = new char[1024];
    int count = read.read(buf, 0, buf.length);
    while (count > 0) {
    writer.write(buf, 0, count );
    count = read.read(buf, 0, buf.length);
    }
    read.close();
    text = new String(writer.toCharArray());
    writer.close();
    }
    else {
    System.out.println("Stream is null");
    return ;
    }
    JFrame frame = new JFrame("Daffodil DB -- Clob Usage");
    frame.setDefaultCloseOperation(frame.HIDE_ON_CLOSE );
    JTextArea label = new JTextArea(text);
    JScrollPane scrollpane = new JScrollPane(label);
    label.setLineWrap(true);
    label.setWrapStyleWord(true);
    frame.getContentPane().add(scrollpane);
    frame.setSize(400, 400);
    frame.show();
    }
    }
    }
    catch (IOException ex) {
    ex.printStackTrace();
    }
    catch (SQLException ex) {
    ex.printStackTrace();
    }
    }



    You can also find the related documentation in DaffodilDB3_1\samples\sample.java in the directory where you have installed the Daffodil DB.

  5. #5
    Join Date
    Jun 2004
    Posts
    2

    Thumbs up data re-sync f

    Hi,

    I have an application that is running on remote machines. I want to enquire whether Daffodil DB provide any way to re-sync the data files in case of loss of network connection.

  6. #6
    Join Date
    Jun 2004
    Posts
    3

    File Not Found

    hi,

    I am trying to use Daffodil DB with DB Visualizer and
    Tomcat and i am getting the error "java.sql.SQLException:
    File Not Found in Jar". I have included the file DaffodilDB_Client.jar in my CLASSPATH
    Can you plz help me with the solution

  7. #7
    Join Date
    Jun 2004
    Posts
    2

    Thumbs up unicode support

    Hello,

    I am using embedded version of Daffodil DB and i want to know how can i create a database with unicode support through code.

  8. #8
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    This forum is for Posting NEWS only. Please post your questions in "Ask an expert" in forums.databasejournal.com

  9. #9
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    This forum is for Posting NEWS only. Please post your questions in "Ask an expert" in forums.databasejournal.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •