Was this helpful?
Working with Locations
After you have created an area for a location, you must then create the location.
A location object specifies the location name, associated area, and the types of files that reside in the location.
You can perform the following basic operations on location objects:
Create and alter location objects
View existing location objects, including the detailed properties of each individual object
Drop location objects
In SQL, you can manage locations using the CREATE LOCATION, ALTER LOCATION, and DROP LOCATION statements. For details, see the SQL Reference Guide.
In Director or VDBA, use the Locations branch.
To work with locations, you need the maintain_locations privilege. This subject privilege is granted by default to the system administrator, who in turn can grant it to other users, such as database administrators, who need to manage locations. For more information on subject privileges, see the Security Guide.
Last modified date: 01/30/2023