Skip to content

terraform provider for Oracle databases support user, grants, roles, etc

License

Notifications You must be signed in to change notification settings

dbgeek/terraform-provider-oraclerdbms

Repository files navigation

Terraform Provider

Maintainers

This provider plugin is not maintained by the Terraform team at HashiCorp.

Requirements

Usage

# For example, restrict oraclerdbms version in 0.1.x
provider "oraclerdbms" {
  version = "~> 0.1"
}

resource "oraclerdbms_profile" "test" {
    profile = "TEST01"
}

resource "oraclerdbms_profile_limit" "test1" {
  resource_name = "IDLE_TIME"
  value         = "33"
  profile       = "${oraclerdbms_profile.test.id}"

}

resource "oraclerdbms_user" "testuser" {
  username            = "TESTUSER"
  default_tablespace  = "USERS"
  profile             = "${oraclerdbms_profile.test.id}
}

resource "oraclerdbms_grant_system_privilege" "grantsysprivs" {
  grantee   = "${oraclerdbms_user.testuser.id}"
  privilege = "CREATE SESSION"
}

resource "oraclerdbms_role" "roletest" {
  role = "TESTROLE"
}

resource "oraclerdbms_grant_role_privilege" "grantroleprivs" {
  grantee = "${oraclerdbms_user.testuser.id}"
  role    = "${oraclerdbms_role.roletest.id}"
}

Building The Provider

Clone repository to: $GOPATH/src/github.com/dbgeek/terraform-provider-oraclerdbms

$ mkdir -p $GOPATH/src/github.com/dbgeek/terraform-provider-oraclerdbms; cd $GOPATH/src/github.com/dbgeek
$ git clone git@github.com:dbgeek/terraform-provider-oraclerdbms

Enter the provider directory and build the provider

$ cd $GOPATH/src/github.com/dbgeek/terraform-provider-oraclerdbms
$ make build

Using the provider

Fill in for each provider

Developing the Provider

If you wish to work on the provider, you'll first need Go installed on your machine (version 1.8+ is required). You'll also need to correctly setup a GOPATH, as well as adding $GOPATH/bin to your $PATH.

To compile the provider, run make build. This will build the provider and put the provider binary in the $GOPATH/bin directory.

$ make bin
...
$ $GOPATH/bin/terraform-provider-oraclerdbms
...

In order to test the provider, you can simply run make test.

$ make test

In order to run the full suite of Acceptance tests, run make testacc.

Note: Acceptance tests create real resources, and often cost money to run.

$ make testacc