Rowset limit syntax

You can specify a rowset limit when you create a user or group. You can also alter the rowset limit of a user or a group. You can specify any number up to 2,147,483,647 or zero, which means unlimited.

  • To create a user with a rowset limit, use the following syntax:
    CREATE USER username WITH ROWSETLIMIT [number | UNLIMITED]
  • To create a group with a rowset limit, use the following syntax:
    CREATE GROUP name WITH ROWSETLIMIT [number | UNLIMITED]
  • To modify a user's rowset limit, use the following syntax:
    ALTER USER username WITH ROWSETLIMIT [number | UNLIMITED]
  • To modify a group's rowset limit, use the following syntax:
    ALTER GROUP name WITH ROWSETLIMIT [number | UNLIMITED]