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]